Citus BlogCitus Blog

With the release of Citus 5.0 in 2016, all pg_shard functionality is included directly in Citus. We encourage you to take a look at Citus, instead of pg_shard which is now deprecated. Citus is available as open source and in the cloud, as the Azure...

Learn how to parallelize analytical queries in PostgreSQL through sharding. Join Marco Slot from Citus Data at 10:00 AM PDT on Wednesday, June 10, 2015 for a webinar which will discuss how to use parallel query execution to speed up queries for an...

PGConf Silicon Valley is a technical conference for the PostgreSQL community scheduled for November 17th and 18th 2015 at the South San Francisco Conference Center. The call for speaking proposals for PGConf Silicon Valley is open until June 15, 2015...

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