Re: good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9

On Thu, Nov 11, 2010 at 11:45 AM, David Fetter <david@fetter.org> wrote:
>> max_prepared_transactions = 100 # guideline: same number as max_connections
>
> This should be either 0 (no 2PC) or the bounded from below by
> max_connections.
>

In general, sure.  I have one app that uses 2PC, and it makes maybe 2%
of the connections, so it is pointless to have it set very high.  If
it were fatal, I'd hope Pg would enforce it with at least a warning.