Citus Blog

Since Postgres started supporting NoSQL (via hstore, json, and jsonb), the question of when to use Postgres in relational mode vs NoSQL mode has come up a lot. Do you entirely abandon traditional table structures, and go with documents all the way? Or do you intermingle both? The answer unsurprisingly is: it depends. Each newer model including hstore, JSON, and JSONB has their ideal use cases. Here we'll dig deeper into each and see when you should consider using them.

PG Conf Silicon Valley is happening again this year in November and we're looking to make it even better and more informative than last year. To do that we're looking to you, both as an attendee and to come speak. We've already received a lot of great...

In the recent 5.1 release of the Citus extension for PostgreSQL, we added the ability to use the COPY command to load data into distributed tables. PostgreSQL's COPY command is one of the most powerful bulk loading features of any database and it is even more powerful on distributed tables.

PostgreSQL is known for its great extensibility and powerful plugins. One particular category of extensions is Foreign Data Wrappers or FDWs. FDWs allow us to interact from within Postgres directly with other data stores such as hdfs, columnar stores, mysql, etc. Combined with Citus’ scalability features, we can even leverage them to help us scale out those data stores where might otherwise be quite difficult.

It may surprise you that pagination, pervasive as it is in web applications, is easy to implement inefficiently. In this article we'll examine several methods of server-side pagination and discuss their tradeoffs when implemented in PostgreSQL. This article will help you identify which technique is appropriate for your situation, including some you may not have seen before which rely on physical clustering and the database stats collector.

PGConf.EU is October 27th through the 30th and we are looking forward to a great event which is drawing a high level of interest from the European PostgreSQL community. Two Citus Data team members will be presenting:

• Andres Freund will present...

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

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