On Wed, May 2, 2012 at 9:38 PM, Daniel Farina <daniel@heroku.com> wrote:
> Besides accuracy, there is a thornier problem here that has to do with
> hot standby (although the use case is replication more generally) when
> one has heterogeneously sized database resources. As-is, it is
> required that locking-related structures -- max_connections,
> max_prepared_xacts, and max_locks_per_xact (but not predicate locks,
> is that an oversight?) must be a larger number on a standby than on a
> primary.
>= not >
so you can use the same values on both sides
Predicate locks aren't set in recovery so the value isn't checked as a
required parameter value.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services