Re: Extend pgbench partitioning to pgbench_history

From: Gabriele Bartolini <gabriele(dot)bartolini(at)enterprisedb(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Extend pgbench partitioning to pgbench_history
Date: 2023-11-30 11:01:54
Message-ID: CA+VUV5qZP3emvE0MkhDEo3jk3YVXkZ5y1hegFTGL3E1t67w3Uw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)bartolini(at)enterprisedb(dot)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
> enterprisedb.com
>

--
Gabriele Bartolini
Vice President, Cloud Native at EDB
enterprisedb.com

Attachment Content-Type Size
0001-Include-pgbench_history-in-partitioning-method-for-p.patch application/octet-stream 7.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ashutosh Bapat 2023-11-30 11:05:11 Re: Report planning memory in EXPLAIN ANALYZE
Previous Message Alexander Lakhin 2023-11-30 11:00:01 Re: Is this a problem in GenericXLogFinish()?