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

From: Jacob Champion <jacob(dot)champion(at)enterprisedb(dot)com>
To: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
Cc: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>, Evgeny Kuzin <evgeny(dot)kuzin(at)outlook(dot)com>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: [PATCH] libpq: try all addresses for a host before moving to next on target_session_attrs mismatch
Date: 2026-05-12 20:48:03
Message-ID: CAOYmi+ngP8oihCTmZrz5hdbuGcRGdp+S6kkpU9Sz95yUd5Fdmw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Mar 12, 2026 at 2:43 PM Greg Sabino Mullane <htamfids(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Zsolt Parragi 2026-05-12 21:05:45 Re: Feature: Use DNS SRV records for connecting
Previous Message Jacob Champion 2026-05-12 20:38:30 Re: [PATCH] libpq: try all addresses for a host before moving to next on target_session_attrs mismatch