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

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9
Date: 2010-11-11 20:30:20
Message-ID: AANLkTimrbyOUOi29_1DPhpbvX5YZwMnxHH8+4X3OWzFi@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Nov 11, 2010 at 11:45 AM, David Fetter <david(at)fetter(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2010-11-11 20:43:05 Re: 2PC w/ dblink
Previous Message Marc Mamin 2010-11-11 19:45:45 Re: Schema tool