Citus Blog

The pg_shard extension helps you scale out PostgreSQL for large data sets by transparently distributing tables across many nodes, storing (replicated) shards of the data as regular PostgreSQL tables on worker nodes. With pg_shard, you can perform INSERT...

Learn how to enable real-time analytics on terabytes of data using PostgreSQL by combining analytics and operational workloads in a single database. Join Utku Azman from Citus Data at 10:00 AM PDT on Wednesday, May 20, 2015 for a webinar which will...

In this post I will present my findings that show a 6x compression of PostgreSQL JSONB data using the cstore_fdw extension. Cstore_fdw is an open source PostgreSQL extension for reducing the storage footprint and speeding up analytical queries. Cstore_fdw...

We're excited to release CitusDB 4.0, pg_shard 1.1, and cstore 1.2! These products extend PostgreSQL for scaling out and high performance.

Now that our new releases are out, we wanted to answer two questions that we continuously hear from our users...

I am hosting a webinar on April 29th at 10:00 am Pacific time to discuss the core principles of PostgreSQL database scaling. The webinar will enable attendees to avoid common mistakes that limit future system capabilities.

During the webinar, I will...

Cloudflare is a content delivery network (CDN) and DNS provider that powers millions of websites around the world. Last week, we were happy to see them publish a technical blog post that described how they power their analytics dashboards using Citus...

We recently attended pgDaySF, the one-day PostgreSQL event organized by the San Francisco PostgreSQL User Group and part of the bigger FOSS4G conference. The event was very well attended, and we were excited by the content of several presentations...

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

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