Re: [PATCH] pgbench: add multiconnect option - Mailing list pgsql-hackers

From David Christensen
Subject Re: [PATCH] pgbench: add multiconnect option
Date
Msg-id CAOxo6XJJDfXqwBvuAbuq1cjKksHdm1D9A7Wihgox1xKb2C+t8A@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] pgbench: add multiconnect option  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: [PATCH] pgbench: add multiconnect option  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-hackers
On Sat, Mar 19, 2022 at 11:43 AM Fabien COELHO <coelho@cri.ensmp.fr> wrote:

Hi Sami,

> Pgbench is a simple benchmark tool by design, and I wonder if adding
> a multiconnect feature will cause pgbench to be used incorrectly.

Maybe, but I do not see how it would be worse that what pgbench already
allows.

I agree that pgbench is simple; perhaps really too simple when it comes to being able to measure much more than basic query flows.  What pgbench does have in its favor is being distributed with the core distribution.

I think there is definitely space for a more complicated benchmarking tool that exercises more scenarios and more realistic query patterns and scenarios.  Whether that is distributed with the core is another question.

David
 

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: refactoring basebackup.c (zstd workers)
Next
From: Andres Freund
Date:
Subject: Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints