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 |
Thread: | |
Lists: | pgsql-hackers |
-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.
Best,
David
Attachment | Content-Type | Size |
---|---|---|
pgbench-add-multiconnect.patch | text/x-patch | 10.9 KB |
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? |