| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>, Jing Wang <jingwangian(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> |
| Subject: | Re: Libpq support to connect to standby server as priority |
| Date: | 2018-07-18 12:53:42 |
| Message-ID: | CA+TgmobfBaNaMrT5Qx+nQ=JKYYy-VOZ2xxXAhAGUSSWZ=fkm4g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Jul 4, 2018 at 9:14 AM, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
> What about keeping the first successful connection open and storing it in a
> variable if we are in "prefer-read" mode.
> If we get the read-only connection we desire, close that cached connection,
> otherwise use it.
I like this idea. If I recall correctly, the logic in this area is
getting pretty complex, so we might need to refactor it for better
readability and maintainability.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2018-07-18 13:01:09 | Re: PG 10: could not generate random cancel key |
| Previous Message | Fabien COELHO | 2018-07-18 12:25:46 | Re: Make foo=null a warning by default. |