Re: pgbench with partitioned tables - Mailing list pgsql-hackers

From Sami Imseih
Subject Re: pgbench with partitioned tables
Date
Msg-id CAA5RZ0sONj-M5Skp=UCj2ZH6OPGSFpvU34Rmjpzy0YAnh51f=Q@mail.gmail.com
Whole thread Raw
List pgsql-hackers
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)



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Increase of maintenance_work_mem limit in 64-bit Windows
Next
From: Antonin Houska
Date:
Subject: Re: why there is not VACUUM FULL CONCURRENTLY?