Re: Extend pgbench partitioning to pgbench_history - Mailing list pgsql-hackers

From Gabriele Bartolini
Subject Re: Extend pgbench partitioning to pgbench_history
Date
Msg-id CA+VUV5qZP3emvE0MkhDEo3jk3YVXkZ5y1hegFTGL3E1t67w3Uw@mail.gmail.com
Whole thread Raw
In response to Extend pgbench partitioning to pgbench_history  (Gabriele Bartolini <gabriele.bartolini@enterprisedb.com>)
Responses Re: Extend pgbench partitioning to pgbench_history
List pgsql-hackers
Please discard the previous patch and use this one (it had a leftover comment from an initial attempt to limit this to hash case).

Thanks,
Gabriele

On Thu, 30 Nov 2023 at 11:29, Gabriele Bartolini <gabriele.bartolini@enterprisedb.com> wrote:
Hi there,

While benchmarking a new feature involving tablespace support in CloudNativePG (Kubernetes operator), I wanted to try out the partitioning feature of pgbench. I saw it supporting both range and hash partitioning, but limited to pgbench_accounts.

With the attached patch, I extend the partitioning capability to the pgbench_history table too.

I have been thinking of adding an option to control this, but I preferred to ask in this list whether it really makes sense or not (I struggle indeed to see use cases where accounts is partitioned and history is not).

Please let me know what you think.

Thanks,
Gabriele
--
Gabriele Bartolini
Vice President, Cloud Native at EDB


--
Gabriele Bartolini
Vice President, Cloud Native at EDB
Attachment

pgsql-hackers by date:

Previous
From: Alexander Lakhin
Date:
Subject: Re: Is this a problem in GenericXLogFinish()?
Next
From: Ashutosh Bapat
Date:
Subject: Re: Report planning memory in EXPLAIN ANALYZE