Re: pgsql: In HS, Startup process sets SIGALRM when waiting for buffer pin.

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Simon Riggs <sriggs(at)postgresql(dot)org>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: In HS, Startup process sets SIGALRM when waiting for buffer pin.
Date: 2010-01-23 17:33:31
Message-ID: 407d949e1001230933v649a2973pc59dfec14844c916@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Sat, Jan 23, 2010 at 4:37 PM, Simon Riggs <sriggs(at)postgresql(dot)org> wrote:
> max_standby_delay = -1 option removed to prevent deadlock.

This seems unacceptable to me. It means it's impossible to configure a
reporting slave so it doesn't spuriously signal errors if your reports
run too long.

Recall that I am still of the opinion that the only reasonable default
value for this parameter is actually -1. I don't think we should
signal errors for correctly working systems unless the user requests
them in some way.

Was there any discussion about this change? I don't recall seeing it
proposed on hackers.

--
greg

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Greg Stark 2010-01-23 17:35:28 Re: pgsql: In HS, Startup process sets SIGALRM when waiting for buffer pin.
Previous Message Simon Riggs 2010-01-23 17:04:05 pgsql: Add explanatory detail to Hot Standby cancelation error messages

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2010-01-23 17:35:28 Re: pgsql: In HS, Startup process sets SIGALRM when waiting for buffer pin.
Previous Message Peter Eisentraut 2010-01-23 17:09:05 tab completion for prepared transactions?