why is max standby delay only 35 minutes?

From: Robert Treat <rob(at)xzilla(dot)net>
To: postgres hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: why is max standby delay only 35 minutes?
Date: 2011-03-04 03:00:38
Message-ID: AANLkTinVKQeO0Zus1sM4ykd1=a8d0YMh437ak3EDfY91@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I have a server where I wanted to do some reporting on a standby, and
wanted to set the max standby delay to 1 hour. upon doing that, i get
this in the logs:

2011-03-03 21:20:08 EST () [2656]: [2-1] user=,db=LOG: received
SIGHUP, reloading configuration files
2011-03-03 21:20:08 EST () [2656]: [3-1] user=,db=LOG: 3600000 is
outside the valid range for parameter "max_standby_archive_delay" (-1
.. 2147483)

The error is clear enough, but is there some reason that the parameter
is coded this way? istm people are much more likely to want to be able
to set the precision in hours than in microseconds.

OTOH, maybe it's a bug? The default resolution is in milliseconds, and
you can't set it to anything less than that (afaict). I asked on irc
and the consensus seemed to be that the internal representation is
off, are we missing something?

Robert Treat
play: xzilla.net
work: omniti.com
hiring: l42.org/Lg

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2011-03-04 04:27:50 Re: Sync Rep v19
Previous Message Jim Nasby 2011-03-04 00:31:20 Re: ALTER TABLE deadlock with concurrent INSERT