Re: [GENERAL] How to use pgbouncer

2010-12-22 Thread Andreas Kretschmer
Filip Rembiałkowski wrote: > 2010/12/21 Andreas Kretschmer : > > > > I'm looking for a solution to split read and write access to different > > servers (streaming replication, you know ...). Can i do that with > > pgpool? (setting backend_weightX=0 or 1)? I have read the doc, but i'm > > not sure

Re: [GENERAL] How to use pgbouncer

2010-12-21 Thread Filip Rembiałkowski
2010/12/21 Andreas Kretschmer : > > I'm looking for a solution to split read and write access to different > servers (streaming replication, you know ...). Can i do that with > pgpool? (setting backend_weightX=0 or 1)? I have read the doc, but i'm > not sure if pgpool the right solution, maybe you

Re: [GENERAL] How to use pgbouncer

2010-12-21 Thread Andreas Kretschmer
Richard Broersma wrote: > 2010/12/21 Filip Rembiałkowski : > >> Or if there is another useful tool available for Connection Pooling. Please > >> guide me for this. > > > > yes there are some; see > > http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling > > > > it depend

Re: [GENERAL] How to use pgbouncer

2010-12-21 Thread Richard Broersma
2010/12/21 Filip Rembiałkowski : >> Or if there is another useful tool available for Connection Pooling. Please >> guide me for this. > > yes there are some; see > http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling > > it depends on what you need. pgbouncer is the small

Re: [GENERAL] How to use pgbouncer

2010-12-21 Thread Filip Rembiałkowski
2010/12/21 Adarsh Sharma : > Dear all, > > I am not able to find any useful document regarding Configuration and > Running Pgbouncer with Postgres-8.4.2. that's strange, there are several good pages on the web; there is also my mini-howto: http://filip.rembialkowski.net/pgbouncer-mini-howto-benchm

[GENERAL] How to use pgbouncer

2010-12-21 Thread Adarsh Sharma
Dear all, I am not able to find any useful document regarding Configuration and Running Pgbouncer with Postgres-8.4.2. How it helps and is it able to boost some performance ? Or if there is another useful tool available for Connection Pooling. Please guide me for this. Thanks & Regards A