Re: [Proxool-developer] Connection release latency when using proxool with PostgreSQL

[Bill H. <bi...@lo...>]

Hi Jean,

On Wed, 2003-12-10 at 11:52, Jean-Henry Berevoescu wrote:

> There is a problem in this new setup: the unused connections are released
> at a slower pace

Can you clarify what you mean by "released"? The life cycle is that a
connection is built, [served, returned,]* destroyed. Which bit is taking
a long time?

> Is there any known issue with proxool when connecting to a PostgreSQL DB 

No.

> The real problem is that I am expecting to reuse connections a lot 

By "reuse" do you mean serve the same connection lots of times? Serving
(and returning) a connection should be very quick.

Have you tried switching trace on? That will give you the performance of
your database calls. Could it be that the database is performing slowly
and that is what is causing many connections to be built?

Regards,
Bill Horsman