The Citus Data

MARCH 1, 2024

When I think about naming something—like a feature or product or even an event—this quote always comes to mind. Which is why we decided to give “Citus Con: An Event for Postgres” a new name. And there are so many useful Postgres extensions (including Citus!) What’s in a name?

Open Source 78

Open Source Virtualization Travel Conference 78

The Citus Data

MARCH 12, 2022

So, in this post I’ll share the tools I built to make it easy to run benchmarks against Postgres—specifically against the Citus extension to Postgres running in a managed database service on Azure called Hyperscale (Citus) in Azure Database for PostgreSQL. OLTP workloads. OLAP workloads. HTAP workloads.

Azure 99

Azure Performance How To Off-The-Shelf 99

The Citus Data

MARCH 5, 2021

Development on Citus first started around a decade ago and once a year we release a major new Citus open source version. Citus 10 extends Postgres (12 and 13) with many new superpowers: Columnar storage for Postgres : Compress your PostgreSQL and Citus tables to reduce storage cost and speed up your analytical queries.

Open Source 143

Open Source Storage Azure Applications 143

The Citus Data

MARCH 6, 2023

Citus is a PostgreSQL extension that makes PostgreSQL scalable by transparently distributing and/or replicating tables across one or more PostgreSQL nodes. Citus could be used either on Azure cloud, or since the Citus database extension is fully open source, you can download and install Citus anywhere you like.

Scalability 112

Scalability Open Source Backup Groups 112

The Citus Data

DECEMBER 5, 2020

Specifically, when to use Hyperscale (Citus), a built-in deployment option in our Azure Database for PostgreSQL managed service. But first: what exactly is Hyperscale (Citus) ? What is Hyperscale (Citus) in Azure Database for PostgreSQL? But first: what exactly is Hyperscale (Citus) ? See Figure 1 below.)

IoT 100

IoT Azure Backup Analytics 100

The Citus Data

DECEMBER 11, 2021

In this post you’ll learn about the database challenges the team faced as the dashboard needed to scale—with an eye toward how the UKHSA team uses Azure, the Azure Database for PostgreSQL managed service, and the Citus extension which transforms Postgres into a distributed database. As a result, the GOV.UK

Azure 87

Azure Open Source Software Review Analytics 87

The Citus Data

MARCH 26, 2022

Today we released Citus 11.0 beta, which is our first ever beta release of the Citus open source extension to Postgres. is that we are introducing a few fundamentally new capabilities, and we would like to get feedback from those of you who use Citus before we release Citus 11.0 The biggest change in Citus 11.0

Testing 126

Testing Load Balancer Open Source Applications 126

The Citus Data

APRIL 9, 2020

The last two months, I managed the agenda for our weekly Citus team meeting, the one time each week where our entire distributed team —with people spread across 6 different countries—gets together to talk about Citus things. Claire: You’ve been working on the Citus documentation since you joined Citus back in 2016.

Open Source 91

Open Source Azure Games Analytics 91

The Citus Data

JANUARY 11, 2022

It’s a free and virtual developer event happening on 12-13 Apr 2022 called Citus Con: An Event for Postgres. Organized by the Postgres and Citus team here at Microsoft Azure, Citus Con is geared toward Postgres users, Azure Database for PostgreSQL customers, and those who use the Citus extension to Postgres (or other PG extensions.).

Conference 131

Conference Video Travel Open Source 131

The Citus Data

DECEMBER 7, 2019

The RQV analytics dashboard relies on Postgres—along with the Citus extension to Postgres to scale out horizontally—and is deployed on Microsoft Azure. Wei discovered the open source Citus extension to Postgres by listening to a recorded conference talk on his drive home.

Azure 53

Azure Analytics Windows Weak Development Team 53

The Citus Data

SEPTEMBER 19, 2020

When working on the internals of Citus , an open source extension to Postgres that transforms Postgres into a distributed database, we often get to talk with customers that have interesting challenges you won’t find everywhere. Just a few months back, I encountered an analytics workload that was a really good fit for Citus.

Engineering 65

Engineering Open Source Analytics Software Review 65

Datavail

JUNE 22, 2021

But that’s not the only reason IT organizations are flocking to Azure. Here are the seven main reasons companies choose this versatile platform: High Availability : Microsoft has a significant global footprint which means Azure can provide a Service Level Agreement (SLA) of 99.95% for its customers.

Azure 40

Azure Artificial Inteligence Cloud Company 40

The Citus Data

FEBRUARY 20, 2021

Because of the richness of PostgreSQL —and features like stored procedures , JSONB , PostGIS for geospatial workloads, and the many useful Postgres extensions, including my personal favorite: Citus. A large chunk of the migrations that I help people with are homogenous Postgres-to-Postgres data migrations to the cloud.

Data 145

Data Azure Performance Windows 145

The Citus Data

JULY 17, 2019

I mean ones like started last week internally among the Azure Postgres team. The first email was titled: Random Citus development and psql tips , and from there it piled on to be more and more tips and power user suggestions for Postgres. I find x lacking, but pspg is great. psqlrc t iming on p set linestyle unicode.

Azure 19

Azure Testing Data Tools 19

The Citus Data

MARCH 3, 2020

Interview with the Postgres committers who have joined the Postgres team at Microsoft by Sudhakar Sannakkayala (Partner Director, Azure Data) and Ozgun Erdogan (Principal, Azure Data)— cross-posted from the Azure Postgres blog. Picture (L-R): Thomas Munro, Jeff Davis, Andres Freund. I think we’re in a new phase now.

Azure 21

Azure Open Source Systems Review Software Review 21

The Citus Data

SEPTEMBER 26, 2019

When Django developer and Azure Postgres * engineer Louise Grandjonc confirmed that she could sit down with me for an interview in the days leading up to DjangoCon 2019 , I jumped at the chance. Editor’s Note: Azure Database for PostgreSQL is a fully-managed database as a service. Let me know if I succeeded. Louise: Yes.

Azure 8

Azure Conference Open Source Examples 8