Search Postgresql Archives

Re: Postres.exe Processes Hang

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Aug 18, 2008 at 9:59 PM, Kim Robinson <Kim.Robinson@xxxxxxxxxxxx> wrote:
> Great thanks all.
> Can you give me any indication of the performance implications of
> setting pooling=false?
>

Yeap. All the time you would need to connect to postgresql you will
have the overhead of tcp connection establishment as well as the
overhead of postgresql authentication.

I don't know how much this is in time, but you can give it a try with
some tests which opens a connection, do a simple query like select
version() and close it.

I think you could see something like 2 or 3 times slower than with the
pool enabled.


-- 
Regards,

Francisco Figueiredo Jr.
http://fxjr.blogspot.com
http://www.npgsql.org


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux