Skip to content
Patch for postgres_fdw foreign data wrapper to be parallel-safe
Branch: master
Clone or download
Latest commit 4b8cdde Jul 23, 2019
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
LICENSE Initial commit Jun 21, 2019
README.md Initial commit Jun 21, 2019
postgres_fdw_parallel_safe_11_4.patch Backport for changes in postgres 11.4 Jul 15, 2019

README.md

Patch to make postgres_fdw parallel-safe

This patch makes the postgres_fdw foreign data wrapper parallel-safe so that shards stored on remote servers can be accessed in parallel via a Parallel Append plan node.

Note, that the patch is experimental.

To compile and use the patch follow these instructions:

  1. Get the PostgreSQL source code, for example via
    • git clone https://github.com/postgres/postgres.git --depth=1 or
    • apt-get source postgresql-11 and sudo apt-get build-dep postgresql-11
  2. Apply the patch from this repository to contrib/postgres_fdw/postgres_fdw.c
  3. Compile PostgreSQL
  4. Copy postgres_fdw.so to /usr/lib/postgresql/11/lib/
  5. Restart PostgreSQL
You can’t perform that action at this time.