Re: pgbench - adding pl/pgsql versions of tests - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: pgbench - adding pl/pgsql versions of tests
Date
Msg-id 20230814150737.GA1395427@nathanxps13
Whole thread Raw
In response to pgbench - adding pl/pgsql versions of tests  (Hannu Krosing <hannuk@google.com>)
Responses Re: pgbench - adding pl/pgsql versions of tests
List 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



pgsql-hackers by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: [PATCH] psql: \dn+ to show size of each schema (and \dA+ for AMs)
Next
From: Florents Tselai
Date:
Subject: Re: Do we want a hashset type?