[PATCH] pgbench: add multiconnect option

From: David Christensen <david(dot)christensen(at)crunchydata(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [PATCH] pgbench: add multiconnect option
Date: 2021-06-30 16:53:03
Message-ID: lzv95vuweo.fsf@veeddrois.attlocal.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


This patch adds the concept of "multiconnect" to pgbench (better
terminology welcome). The basic idea here is to allow connections made
with pgbench to use different auth values or connect to multiple
databases. We implement this using a user-provided PGSERVICEFILE and
choosing a PGSERVICE from this based on a number of strategies.
(Currently the only supported strategies are round robin or random.)

There is definite room for improvement here; at the very least, teaching
`pgbench -i` about all of the distinct DBs referenced in this service
file would ensure that initialization works as expected in all places.
For now, we are punting initialization to the user in this version of
the patch if using more that one database in the given service file.



Attachment Content-Type Size
pgbench-add-multiconnect.patch text/x-patch 10.9 KB


Browse pgsql-hackers by date

  From Date Subject
Next Message John Naylor 2021-06-30 16:54:23 Re: speed up verifying UTF-8
Previous Message Bruce Momjian 2021-06-30 16:35:16 Re: Have I found an interval arithmetic bug?