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.