Horton

Re: pgbench: option delaying queries till connections establishment?

Fabien COELHO <coelho@cri.ensmp.fr>

View thread View on postgr.es
From: Fabien COELHO <coelho@cri.ensmp.fr>
To: Andres Freund <andres@anarazel.de>
Cc: Alexander Korotkov <aekorotkov@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2020-11-17T05:58:35Z
Lists: pgsql-hackers 
> I think the issue really is that, independent of PG lock contention,
> it'll take a while to establish all connections, and that starting to
> benchmark with only some connections established will create pretty
> pointless numbers.

Yes. This is why I think that if we have some way to synchronize it should 
always be used, i.e. not an option.

-- 
Fabien.

Commits

  1. Fix new pthread code to respect --disable-thread-safety.

  2. Add missing pthread_barrier_t.

  3. pgbench: Improve time logic.

  4. pgbench: Refactor thread portability support.

  5. pgbench: Synchronize client threads.

  6. Fix bogus logic for skipping unnecessary partcollation dependencies.