Horton
Menu

Re: max_standby_delay considered harmful

Simon Riggs <simon@2ndquadrant.com>

View thread
From: Simon Riggs <simon@2ndQuadrant.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>, Tom Lane <tgl@sss.pgh.pa.us>, Greg Smith <greg@2ndquadrant.com>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, pgsql-hackers@postgresql.org
Date: 2010-05-06T07:34:29Z
Lists: pgsql-hackers 
On Thu, 2010-05-06 at 00:47 -0400, Robert Haas wrote: 

> That just doesn't sound that bad to me, especially since the proposed
> alternative is:
> 
> - Queries will get cancelled like crazy, period.
> 
> Or else:
> 
> - Replication can fall infinitely far behind and you can write a
> tedious and error-prone script to try to prevent it if you like.
> 
> I think THAT is going to tarnish our reputation.

Yes, that will.

There is no consensus to remove max_standby_delay.

It could be improved with minor adjustments and it makes more sense to
allow a few of those, treating them as bugs.

-- 
 Simon Riggs           www.2ndQuadrant.com