Re: performance config help

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Bob Dusek <redusek(at)gmail(dot)com>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: performance config help
Date: 2010-01-14 10:44:15
Message-ID: 87eilt9da8.fsf@hi-media-techno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Bob Dusek <redusek(at)gmail(dot)com> writes:
> So, pgBouncer is pretty good. It doesn't appear to be as good as
> limiting TCON and using pconnect, but since we can't limit TCON in a
> production environment, we may not have a choice.

You can still use pconnect() with pgbouncer, in transaction mode, if
your application is compatible with that (no advisory locks or other
session level tricks).

Regards,
--
dim

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message fkater@googlemail.com 2010-01-14 14:29:03 Inserting 8MB bytea: just 25% of disk perf used?
Previous Message Craig Ringer 2010-01-14 05:47:13 Re: performance config help