Horton

Re: [PATCH] libpq: try all addresses for a host before moving to next on target_session_attrs mismatch

Jacob Champion <jacob.champion@enterprisedb.com>

View thread
From: Jacob Champion <jacob.champion@enterprisedb.com>
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: Zsolt Parragi <zsolt.parragi@percona.com>, Evgeny Kuzin <evgeny.kuzin@outlook.com>, Laurenz Albe <laurenz.albe@cybertec.at>, Tom Lane <tgl@sss.pgh.pa.us>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Date: 2026-05-12T20:48:03Z
Lists: pgsql-hackers 
On Thu, Mar 12, 2026 at 2:43 PM Greg Sabino Mullane <htamfids@gmail.com> wrote:
> I'm still a big +1 to the original proposal in this thread, and don't think it would be incompatible with happy eyeballs. Although I would think the latter would be quite wasteful, as we are not simply checking for a response, but doing a whole connect/authenticate/get-status dance.

Just to make it clear, this is the opposite of what I'm arguing for.
Happy Eyeballs implementations should not couple to application-level
concerns, and we should not have to open up a bazillion concurrent
connections just to find the single read/write leader.

--Jacob