I think that pgbench should it make it easy to assess the impact of foreign key constraints.
The attached adds a --foreign-keys option to initialization mode which creates all the relevant constraints between the default tables. I changed the order of the table DDLs so that upon reinitialization the tables are dropped in an order that does not lead to dependency problems. I'll add it CFNext. Thanks, Jeff
pgbench_key_v1.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers