Re: max_standby_delay considered harmful - Mailing list pgsql-hackers

From Greg Stark
Subject Re: max_standby_delay considered harmful
Date
Msg-id AANLkTimhpTNCSglw6D889Wy9-MRseY9UmloWkZlecHMF@mail.gmail.com
Whole thread Raw
In response to Re: max_standby_delay considered harmful  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On Wed, May 12, 2010 at 12:26 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> On Wed, 2010-05-12 at 07:10 -0400, Robert Haas wrote:
>
>> I'm not sure what to make of this.  Sometimes not shutting down
>> doesn't sound like a feature to me.
>
> It acts exactly the same in recovery as in normal running. It is not a
> special feature of recovery at all, bug or otherwise.

I admit I've sometimes been surprised that smart shutdown was waiting
when I didn't expect it to.

It would be good to give the shutdown more feedback. If it explicitly
shows "Waiting for n sessions with active transactions to commit" or
"Waiting for n sessions to disconnect" then the user would at least
understand why it was waiting and what would be necessary to get it to
continue.


--
greg


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: max_standby_delay considered harmful
Next
From: Robert Haas
Date:
Subject: Re: max_standby_delay considered harmful