| From: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
|---|---|
| To: | Hannu Krosing <hannuk(at)google(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Dimitri Fontaine <dim(at)tapoueh(dot)org> |
| Subject: | Re: pgbench - adding pl/pgsql versions of tests |
| Date: | 2023-08-14 15:07:37 |
| Message-ID: | 20230814150737.GA1395427@nathanxps13 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Jan 04, 2023 at 07:06:44PM +0100, Hannu Krosing wrote:
> 1. so I don't have to create the script and function manually each
> time I want to test mainly the database (instead of the
> client-database system)
>
> 2. so that new users of PostgreSQL can easily see how much better OLTP
> workloads perform when packaged up as a server-side function
I'm not sure we should add micro-optimized versions of the existing scripts
to pgbench. Your point about demonstrating the benefits of server-side
functions seems reasonable, but it also feels a bit like artifically
improving pgbench numbers. I think I'd rather see some more variety in the
built-in scripts so that folks can more easily test a wider range of common
workloads. Perhaps this could include a test that is focused on
server-side functions.
In any case, it looks like there is unaddressed feedback for this patch, so
I'm marking it as "waiting on author."
--
Nathan Bossart
Amazon Web Services: https://aws.amazon.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Florents Tselai | 2023-08-14 15:23:04 | Re: Do we want a hashset type? |
| Previous Message | Justin Pryzby | 2023-08-14 15:03:16 | Re: [PATCH] psql: \dn+ to show size of each schema (and \dA+ for AMs) |