Re: [GENERAL] Template zero xid issue - Mailing list pgsql-hackers

From Decibel!
Subject Re: [GENERAL] Template zero xid issue
Date
Msg-id 20070808050927.GD25704@nasby.net
Whole thread Raw
In response to Re: [GENERAL] Template zero xid issue  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [GENERAL] Template zero xid issue  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, Aug 07, 2007 at 06:46:05PM -0400, Tom Lane wrote:
> I'm tempted to stop accepting connections once we start the shutdown
> checkpoint (ie, tell the bgwriter to shut down).  This would at least
> limit the width of the window in which incoming connections get ignored.
> We could also close the sockets at that point, so that clients get an
> immediate failure instead of hanging for awhile --- then it will look
> to them like the postmaster is already gone.

Well, we're effectively shutdown at that point... I don't see much
benefit to sending a "We're in the middle of shutting down" message over
"couldn't connect to the server", which is what the client would have
gotten anyway in very short order.
--
Decibel!, aka Jim Nasby                        decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

pgsql-hackers by date:

Previous
From: "Jaime Casanova"
Date:
Subject: Re: 76AC-752C-3D91 : CONFIRM from pgsql-hackers (subscribe)
Next
From: Jeremy Drake
Date:
Subject: Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions]