Citus BlogCitus Blog

CitusDB scales out PostgreSQL across commodity servers and processes queries in parallel. Many CitusDB users deploy it on Amazon Web Services (AWS) using Elastic Compute Cloud (EC2), which allows them to easily scale out the number of nodes. However...

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...

We're excited to announce general availability of CitusDB 4.0, which is based on the new PostgreSQL 9.4 release. CitusDB is our full featured, turnkey database solution for fully scalable, highly-available PostgreSQL. A licensed solution, CitusDB allows...

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...