pg_fkpart

pig build pkg pg_fkpart;		# build deb

pig repo add pgsql -u   # add both repo and update cache

pig install pg_fkpart;		# install via package name, for the active PG version

pig install pg_fkpart -v 18;   # install for PG 18
pig install pg_fkpart -v 17;   # install for PG 17
pig install pg_fkpart -v 16;   # install for PG 16
pig install pg_fkpart -v 15;   # install for PG 15
pig install pg_fkpart -v 14;   # install for PG 14

CREATE EXTENSION pg_fkpart;

CREATE EXTENSION pg_fkpart;

SELECT pgfkpart.partition_with_fk(
    'public',           -- schema of the table to partition
    'my_table',         -- table to partition
    'public',           -- schema of the foreign key table
    'fk_table',         -- foreign key table
    true                -- support SQL RETURNING
);

SELECT pgfkpart.unpartition_with_fk('public', 'my_table');

SELECT pgfkpart.dispatch_index('public', 'my_table');

SELECT pgfkpart.drop_index('public', 'my_table', 'my_index_name');

SELECT pgfkpart.drop_unique_constraint('public', 'my_table', 'my_constraint_name');