Re: Unnecessary limit on max_standby_streaming_delay - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Unnecessary limit on max_standby_streaming_delay
Date
Msg-id 201103110320.p2B3KFn13624@momjian.us
Whole thread Raw
In response to Re: Unnecessary limit on max_standby_streaming_delay  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut wrote:
> On fre, 2010-12-17 at 12:57 +0100, Magnus Hagander wrote:
> > The limit on max_standby_streaming_delay is currently 35 minutes
> > (around) - or you have to set it to unlimited. This is because the GUC
> > is limited to MAX_INT/1000, unit milliseconds.
> > 
> > Is there a reason for the /1000, or is it just an oversight thinking
> > the unit was in seconds?
> 
> Yeah, I actually noticed this week that log_min_duration_statement is
> limited to the same 35 minutes for the same reason.  Might be good to
> address that, too.  Note that statement_timeout does not have that
> limit.

Added to TODO:
Increase maximum values for max_standby_streaming_delay andlog_min_duration_statement    *
http://archives.postgresql.org/pgsql-hackers/2010-12/msg01517.php
 

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: function(contants) evaluated for every row
Next
From: Bruce Momjian
Date:
Subject: Re: psql expanded auto