Re: Any better plan for this query?.. - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: Any better plan for this query?..
Date
Msg-id 20090512235418.GB6031@alvh.no-ip.org
Whole thread Raw
In response to Re: Any better plan for this query?..  (Dimitri Fontaine <dfontaine@hi-media.com>)
List pgsql-performance
Dimitri Fontaine escribió:

> A much better idea to solve this, in my opinion, would be to have
> pgbouncer as a postmaster child, integrated into PostgreSQL. It allows
> for choosing whether you want session pooling, transaction pooling or
> statement pooling, which is a more deterministic way to choose when your
> client connection will benefit from a fresh backend or an existing one.
> And it's respecting some backend timeouts etc.

Hmm.  Seems like the best idea if we go this route would be one of
Simon's which was to have better support for pluggable postmaster
children.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-performance by date:

Previous
From: Thomas Finneid
Date:
Subject: increase index performance
Next
From: Greg Stark
Date:
Subject: Re: Any better plan for this query?..