Marco Slot

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.

Product search is a common, yet sometimes challenging use-case for online retailers and marketplaces. It typically involves a combination of full-text search and filtering by attributes which differ for every product category. More complex use-cases may have many sellers that offer the same product, but with a different price and different properties.

With the Citus extension, you can use PostgreSQL to build applications that interactively query large data sets, for example analytical dashboards. At the same time, you can keep adding new data at high rates and use PostgreSQL's powerful indexing...

I'm pleased to present an abbreviated version of the tutorial we presented at PGConf Silicon Valley on "Real-Time Analytics in PostgreSQL". Please join me on Wednesday, December 9th at 10 am PST for a webinar in which I will demonstrate how to perform...

The Paxos algorithm is a powerful building block for building highly available distributed systems. Paxos can be seen as a function paxos(k,v) that returns the same value on all servers in a group for a certain key (k), and the value is one of the...

In our recent webinar on Scaling PostgreSQL on Amazon Web Services using pg_shard and CitusDB, we received a number of interesting questions, particularly about CitusDB, which transparently shards tables and parallelizes queries across a cluster of...

Join us on October 14th at 10 am Pacific Time when I will present our latest webinar entitled "Scaling PostgreSQL on Amazon Web Services." PostgreSQL is often used in Amazon Web Services (AWS) deployments as a versatile data store. However, PostgreSQL...

One of the upcoming features in PostgreSQL 9.5 is foreign table inheritance, which offers a suite of new possibilities for users of foreign data wrappers. An exciting possibility is that you will be able to create a single table in which recent data...

On October 8th at 17:30 the second Dutch PostgreSQL meetup will be held in Amsterdam. Please join us for some very interesting talks.

Andres Freund, a PostgreSQL committer and developer working at Citus Data, will speak about major scalability improvements...

Update: As of Citus 5.0, Citus is now open source, and all pg_shard functionality is included directly in the Citus extension to Postgres. We encourage you to take a look at Citus instead. You can download Citus open source packages for single-machine...