Skip to content

WIP / experimental: Postgres partitions + FDW

Andreas Brandl requested to merge ab/foreign-partitions into master

gitlab-org/database-team/team-tasks#53 (closed)

Experimental branch for using postgres declarative partitioning in combination with foreign data wrappers to push partitions to a foreign server.

We're tackling one table of the GitLab schema here, creating 8 partitions and distributing them on 2 shards. Shard in this example is a local database, which can also live on a remote cluster.

Demo: https://www.youtube.com/watch?v=MiZFtM84x44

Merge request reports