Postgres sharding with partitioning and FDW

This issues is about hacking on a postgres sharding solution using declarative partitioning and foreign data wrappers (FDW). Using it to put my notes here.

This is a smaller cut of #52 (closed) - to only do the schema changes necessary to setup a single table with two shards.

In this example, I'm taking issues and two local databases serve as shards. We partition issues by HASH(project_id) (for the sake of the example since this is already available). We create 8 partitions and distribute them to 2 shards. The shards are local databases on the same cluster in this example (would later be moved to their own cluster).

Edited Apr 29, 2020 by Andreas Brandl
Assignee Loading
Time tracking Loading