pgbench_accounts is the only table that should grow to
the point where partitioning can benefit the tpcb-like
benchmark.

It looks like you have customized the pgbench
schema that partitions the other pgbench tables, so
you can use a custom script to initialize the data.

IMO, If there is a good reason to allow the other pgbench
tables to be partitioned, that may be better to think
about. I am not sure there is though.

Regards,

Sami
Amazon Web Services (AWS)


Reply via email to