Connection pooling

From: "Max Zorloff" <zorloff(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Connection pooling
Date: 2007-09-06 16:08:21
Message-ID: op.tx8pr7sgll0p5y@1-rtt202dnf3uds.mshome.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello. I'm using Apache + PHP + Postgres for my project. I've tried the
two poolers people
usually recommend here - pgbouncer and pgpool.

I have a problem with pgbouncer - under the load the query execution
becomes ~10 times slower
than it should be - basically to test it, I connect with psql
(establishing connection becomes
somewhat slow under load) and use \timing to measure execution time. The
basic query of
"select * from aaa where id = 1" runs 10 times slower than it should. If I
connect with psql
directly to postgres, the execution time is acceptable. Does anyone know
what is the problem?

The pgpool (I tried 3.1, 3.4 and pgpool-II 1.2) works fine but has the
following problem - after some time it
just "hangs", and if I try to connect to it with psql it just hangs
indefinitely. After restart
it works fine again. I turned off persistent connections in php so it's
not that. Does anybody
have the same problem?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Webb Sprague 2007-09-06 17:08:05 Do AGGREGATES consistently use sort order?
Previous Message Alban Hertroys 2007-09-06 15:56:30 Re: ANY