Re: Postgre Performance

Here you go..

http://winpg.jp/~saito/pgbouncer/pgbouncer-1.4-win32.zip

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/

On Tue, Oct 18, 2011 at 11:08 PM, Deshpande, Yogesh Sadashiv (STSD-Openview)
<yogesh-sadashiv(dot)deshpande(at)hp(dot)com> wrote:

> I am not able to find binary distribution of pgbouncer for windows.. Can
> you point me to the location?****
>
> ** **
>
> *From:* Raghavendra [mailto:raghavendra(dot)rao(at)enterprisedb(dot)com]
> *Sent:* Tuesday, October 18, 2011 10:33 PM
> *To:* Bill Moran
> *Cc:* Deshpande, Yogesh Sadashiv (STSD-Openview);
> pgsql-general(at)postgresql(dot)org
>
> *Subject:* Re: [GENERAL] 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****
>