Request a Demo
Home   >   mailing lists

Re: Pgbench: remove synchronous prepare - Mailing list pgsql-hackers

From Dmitrii Bondar
Subject Re: Pgbench: remove synchronous prepare
Date
Msg-id 980f17ee-1a2b-4feb-9286-01690eb3be20@postgrespro.ru
Whole thread
In response to Re: Pgbench: remove synchronous prepare  (lakshmi <lakshmigcdac@gmail.com>)
Responses Re: Pgbench: remove synchronous prepare
List pgsql-hackers
Tree view

Hi!

Thank you for reviewing my patch! Should I consider your review complete and move the patch to ‘ready for committer’?

On 4/6/26 1:54 PM, lakshmi wrote:


On Mon, Mar 23, 2026 at 11:45 AM Dmitrii Bondar <d.bondar@postgrespro.ru> wrote:
Rebase.

Hi Dmitrii,

I tested the latest patch with PgBouncer in session pooling mode (pool size 20, 21 clients).

Before applying the patch, pgbench got stuck under this setup and eventually hit a query_wait_timeout error.

After applying the patch, pgbench runs smoothly even when clients are queued. I can see continuous progress output and normal throughput (~60k TPS), with no errors or stalls.

The change works well in my testing.

Thanks for the patch!

Regards,
Lakshmi G

pgsql-hackers by date:

Previous
From: Nishant Sharma
Date:
Subject: Re: [BUG] CRASH: ECPGprepared_statement() and ECPGdeallocate_all() when connection is NULL
Next
From: Alexander Korotkov
Date:
Subject: Re: [PATCH] Fix WAIT FOR LSN standby_write/standby_flush for archive recovery cases