public inbox for [email protected]
help / color / mirror / Atom feedFrom: Jim Nasby <[email protected]>
To: Tomas Vondra <[email protected]>
Cc: Jelte Fennema-Nio <[email protected]>
Cc: Zsolt Parragi <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Cc: Dave Cramer <[email protected]>
Cc: Jacob Champion <[email protected]>
Cc: Heikki Linnakangas <[email protected]>
Subject: Re: Add GoAway protocol message for graceful but fast server shutdown/switchover
Date: Mon, 23 Mar 2026 17:34:35 -0500
Message-ID: <CAMFBP2rSvyj6DYAw0EEBGR2UUP85ByKAC_D0djJm7rdypuMvdQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
<CAN4CZFOw2v9G_9vuP0vnNH8K9X_UeSOyq=gWJp7bdGZ5HKNTDA@mail.gmail.com>
<[email protected]>
<[email protected]>
<CAN4CZFMLpakQb8qohDAnrOoQ1-UrvmzJewZss95Y+Mf_J+iNeA@mail.gmail.com>
<[email protected]>
<[email protected]>
On Fri, Mar 20, 2026 at 2:20 PM Tomas Vondra <[email protected]> wrote:
> * Does it make sense to tie this to smart shutdowns? I realize it's just
> an example, and it probably makes sense to send the GoAway message
> before a shutdown. But isn't this a bit similar to cancel/terminate of a
> backend? Why not to have a pg_goaway_backend() function, that'd send the
> message to a single backend? It might be useful for load-balancing, if
> we could pick a "heavy" backend and ask it to reconnect / move to a
> different replica. (Could that be handled by a middleware?)
>
+1. Another scenario that comes to mind is asking for a reconnect based on
backend memory consumption, since there's a bunch of internal structures
(relcache, etc) that can grow in an unbounded fashion.
view thread (15+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Add GoAway protocol message for graceful but fast server shutdown/switchover
In-Reply-To: <CAMFBP2rSvyj6DYAw0EEBGR2UUP85ByKAC_D0djJm7rdypuMvdQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox