On Thu, Nov 11, 2010 at 11:45 AM, David Fetter <david@xxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general