From: | Jelte Fennema <Jelte(dot)Fennema(at)microsoft(dot)com> |
---|---|
To: | "kuroda(dot)hayato(at)fujitsu(dot)com" <kuroda(dot)hayato(at)fujitsu(dot)com> |
Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Support load balancing in libpq |
Date: | 2022-07-15 14:59:55 |
Message-ID: | DB7PR83MB0284A1221D88982A38B22310F78B9@DB7PR83MB0284.EURPRD83.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> we can assume that one of members is a primary and others are secondary.
With plain Postgres this assumption is probably correct. But the main reason
I'm interested in this patch was because I would like to be able to load
balance across the workers in a Citus cluster. These workers are all primaries.
Similar usage would likely be possible with BDR (bidirectional replication).
> In this case user maybe add a primary host to top of the list,
> so sorting may increase time durations for establishing connection.
If the user takes such care when building their host list, they could simply
not add the load_balance_hosts=true option to the connection string.
If you know there's only one primary in the list and you're looking for
the primary, then there's no reason to use load_balance_hosts=true.
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2022-07-15 15:17:24 | Re: Add function to return backup_label and tablespace_map |
Previous Message | Masahiko Sawada | 2022-07-15 14:39:00 | Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns |