Citus BlogCitus Blog

Last month we went to PGConf.Russia and gave a talk on [pg_shard](/citus-products/pg-shard) which is available for download on GitHub. pg_shard is an open source PostgreSQL extension which allows users to scale out their database by creating a cluster...

Last winter, we open-sourced pg_shard, a transparent sharding extension for PostgreSQL. It brought straightforward sharding capabilities to PostgreSQL, allowing tables and queries to be distributed across any number of servers.

Today we’re excited...

Citus Data is excited to announce the release of cstore_fdw 1.2, which is available on GitHub at https://github.com/citusdata/cstore_fdw. Cstore_fdw is Citus Data's open source columnar store extension for PostgreSQL.

The changes in this release include...

One of the nice things about working at Citus Data is that we get time and budget to work on personal growth projects. A few of us are playing with the Raspberry Pi. I recently got two Raspberry Pi 2's and installed the Raspbian distribution on 16GB...

The first distributed database that I worked on was called CSPIT. The project was led by a visionary architect and involved some of the smartest developers I knew at Amazon.

CSPIT never saw the light of day. On the technical side, we ran into scalability...

Last week we were at one of the biggest PostgreSQL events ever held. Nope, it wasn't PGCon, it was the inaugural PGConf.Russia in Moscow. The conference included some very interesting talks. We were especially excited to learn more about several extensions...

This blog post simplifies certain concepts to be brief. If you're looking for examples on how to override the PostgreSQL planner and executor, please check out Citus on GitHub or download Citus here.

By now, you've likely heard the line "SQL doesn...

Notice: Citus is now a successor to pg_shard. We encourage you to take a look at it if you need help with Postgres sharding.

Today we’re excited to announce pg_shard, a transparent sharding extension for PostgreSQL. Without requiring any changes to...

PostgreSQL is one of the most popular open-source databases thanks to its reliability and advanced feature set. At Citus Data, we scale out PostgreSQL across many machines to enable queries over large datasets. We are often asked how CitusDB performance...

One of the ideas we wanted to explore more has been speeding up in-memory aggregations in PostgreSQL through vectorized execution. The opportunity to do so came up when we had our intern, Can, take this on as a project during his summer internship...