On Sat, Oct 31, 2026 at 7:58 PM Roman Khapov <[email protected]> wrote: > So the attached patch keeps PERMANENT, when partitioning is in use, for > exactly two tables: pgbench_accounts and pgbench_branches.
Thanks for the report and patch! Users who specify --unlogged-tables would expect all data tables to be unlogged, so keeping pgbench_branches logged seems undesirable to me. When using --partitions, --unlogged-tables, and --foreign-keys together, users would expect partitioned accounts, unlogged data tables, and working foreign keys, as documented. So, isn't it better to keep all data tables unlogged and define the foreign key from each accounts partition to pgbench_branches instead of from the partitioned parent? Regards, -- Fujii Masao
