[Pgpool-general] What is the performance penalty of using pgpool

Jaume Sabater jsabater at gmail.com
Wed Aug 12 16:15:48 UTC 2009


On Wed, Aug 12, 2009 at 5:23 PM, Tatsuo Ishii<ishii at sraoss.co.jp> wrote:

> However if there's only one session, we could issue INSERT
> concurrently to both nodes. This would be a good optimization and may
> be a TODO item if there's enough interest.

What would you understand as one session? One client only? In case of
web server farms, that would never be the case, would it?

> Also note that if you have the third node, time taken will be 100%,
> not 200%. This is because pgpool issue INSERT concurrently for the
> second and the third node.

That answers the question in my just sent mail for the previous thread :)

-- 
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"


More information about the Pgpool-general mailing list