On Fri, Jan 31, 2025 at 2:27 PM Sami Imseih <samimseih@gmail.com> wrote:
>
> pgbench_accounts is the only table that should grow to
> the point where partitioning can benefit the tpcb-like
> benchmark.
pgbench_history is append-only, so I could see the argument for
partitioning that.
> 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.
see this thread [1] proposing partitioning pgbench_history last year.
[1]
https://www.postgresql.org/message-id/flat/CAAKRu_Zo8ST-Qk8VQ4KFkbMQcqJsQQz5r%2BYRRbecS3avgkoZhw%40mail.gmail.com#ca9397c201ed483cb02f07dcaaa2773c
