| From: | Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | laurenz(dot)albe(at)cybertec(dot)at, 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-19 12:59:28 |
| Message-ID: | CAJrrPGea1hX5HmZyVzhJ3HbT8x3+2zoNp48HhPVFzQUYy5PU_w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Jul 18, 2018 at 10:53 PM Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> 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.
>
OK. I will work on the code refactoring first and then provide the
prefer-read option on top it.
Regards,
Haribabu Kommi
Fujitsu Australia
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2018-07-19 13:03:28 | Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian |
| Previous Message | Haribabu Kommi | 2018-07-19 12:55:44 | Re: [bug fix] Produce a crash dump before main() on Windows |