PostgreSQL as a Distributed Computing Platform

3a932587ce6bcaa5e118198dc4c05d3c?s=47 Marco Slot
September 08, 2017

PostgreSQL as a Distributed Computing Platform

One of the unique things about postgres is that extensions can add new functionality that falls outside the scope of a SQL database. Several postgres extensions add the ability to perform commands or query data on other servers. These extensions can be combined in interesting ways to form advanced distributed systems on top of postgres.

In this talk, I explore how extensions such as dblink, postgres_fdw, pglogical, pg_cron, and Citus together with PL/pgSQL can be used as building blocks for distributed systems. I also give a demonstration of using PostgreSQL as a distributed computing platform, including a Kafka-like distributed queue built on top of postgres.


Marco Slot

September 08, 2017