Re: max_standby_delay considered harmful - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: max_standby_delay considered harmful
Date
Msg-id 4BE30EAE.6050207@agliodbs.com
Whole thread Raw
In response to Re: max_standby_delay considered harmful  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: max_standby_delay considered harmful
List pgsql-hackers
> Now that I've realized what the real problem is with max_standby_delay
> (namely, that inactivity on the master can use up the delay), I think
> we should do what Tom originally suggested here.  It's not as good as
> a really working max_standby_delay, but we're not going to have that
> for 9.0, and it's clearly better than a boolean.

I guess I'm not clear on how what Tom proposed is fundamentally
different from max_standby_delay = -1.  If there's enough concurrent
queries, recovery would never catch up.

--                                  -- Josh Berkus                                    PostgreSQL Experts Inc.
                        http://www.pgexperts.com
 


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: SQLSTATE for Hot Standby cancellation
Next
From: Robert Haas
Date:
Subject: Re: max_standby_delay considered harmful