Citus Data Blog

Making PostgreSQL Scale Hadoop-style: Benchmark Numbers

Linux memory manager and your big data

Citus gives you all the greatness of Postgres plus the superpowers of distributed tables. By distributing your data and queries, your application gets high performance—at any scale. The Citus database is available as open source and as a managed service on Azure.

PostgreSQL columnar store benchmarks on SSDs

Citus gives you all the greatness of Postgres plus the superpowers of distributed tables. By distributing your data and queries, your application gets high performance—at any scale. The Citus database is available as open source and as a managed service on Azure.

Pg_paxos: High Availability Data Replication for PostgreSQL

Running PostgreSQL on Compression-enabled ZFS

Citus gives you all the greatness of Postgres plus the superpowers of distributed tables. By distributing your data and queries, your application gets high performance—at any scale. The Citus database is available as open source and as a managed service on Azure.

Databases and Distributed Deadlocks: A FAQ

A developer FAQ created by the Citus engineering team when they first began working on distributed deadlock detection in the Citus database. Explores when PostgreSQL acquires locks, when deadlocks occur, and how Citus detects and prevents distributed deadlocks in Postgres.

How to Build Your Distributed Database

Citus gives you all the greatness of Postgres plus the superpowers of distributed tables. By distributing your data and queries, your application gets high performance—at any scale. The Citus database is available as open source and as a managed service on Azure.

Postgres data types you should consider using

PostgreSQL has a rich collection of extensions and nearly 100 different data types, each with their own tuned indexing or specialized functions. You probably already use integers and text, and today we're going to explore a few less-used but incredibly powerful PostgreSQL data types.

Citus Cloud 2, Postgres, and Scaling Without Compromise

Relational databases have been a mainstay for decades. But what happens when you need to scale out a relational database like Postgres? This post announces Citus Cloud 2, the latest version of the Citus managed database as a service that scales out Postgres horizontally in the cloud.

Fun with SQL: Window Functions in Postgres

Window functions in PostgreSQL are valuable when you want to compare & contrast data between rows. And window functions are key in analytics use cases. This post covers the basic structure of window functions as well as some of the more interesting things you can do with them.

Run SQL on JSON files without any data loads

Citus gives you all the greatness of Postgres plus the superpowers of distributed tables. By distributing your data and queries, your application gets high performance—at any scale. The Citus database is available as open source and as a managed service on Azure.

PostgreSQL, pg_shard, and what we learned from our failures

Real-time event aggregation at scale using Postgres with Citus

Citus is commonly used to scale out event data pipelines on top of PostgreSQL. Its ability to transparently shard data and parallelise queries over many machines makes it possible to have real-time responsiveness even with terabytes of data.

Run SQL on MongoDB