Search Postgresql Archives

Re: Postgre Performance

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

 



I am not able to find binary distribution of pgbouncer for windows.. Can you point me to the location?

 

From: Raghavendra [mailto:raghavendra.rao@xxxxxxxxxxxxxxxx]
Sent: Tuesday, October 18, 2011 10:33 PM
To: Bill Moran
Cc: Deshpande, Yogesh Sadashiv (STSD-Openview); pgsql-general@xxxxxxxxxxxxxx
Subject: Re: Postgre Performance

 

> We need following information
>
> 1.       Is there any configuration we do that would pool the connection request rather than coming out with connection limit exceed.

Use pgpool or pgbouncer.

 

 

Use pgbouncer, which is a light weighted connection pooling tool, if you are not opting for load balancing.

 


> Basically we wanted to limit the number of processes so that client code doesn't have to retry for unavailability for connection or sub processes , but postgre takes care of queuing?

 

For controlling unavailability of connections, it may be possible at application level but its not possible at Database level. However, if connections reaches max limit, DB will alert you as it reached max_connection.

 

--Raghav


[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