Re: performance config help - Mailing list pgsql-performance

From Dimitri Fontaine
Subject Re: performance config help
Date
Msg-id 87eilt9da8.fsf@hi-media-techno.com
Whole thread Raw
In response to Re: performance config help  (Bob Dusek <redusek@gmail.com>)
List pgsql-performance
Bob Dusek <redusek@gmail.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

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: performance config help
Next
From: "fkater@googlemail.com"
Date:
Subject: Inserting 8MB bytea: just 25% of disk perf used?