Re: [PERFORM] How clustering for scale out works in PostgreSQL

2013-08-29 Thread bsreejithin
Ya..sure...Migration to 9.2 is one of the activities planned and in fact it's already on track.Thanks Thomas On Thu, Aug 29, 2013 at 11:16 PM, Thomas Kellerer [via PostgreSQL] < ml-node+s1045698n5768973...@n5.nabble.com> wrote: > bsreejithin wrote on 29.08.2013 18:13: > > Po

Re: [PERFORM] How clustering for scale out works in PostgreSQL

2013-08-29 Thread bsreejithin
Thanks Joshua..Will look to use connection pooler which Igor mentioned.. -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-clustering-for-scale-out-works-in-PostgreSQL-tp5768917p5768961.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

Re: [PERFORM] How clustering for scale out works in PostgreSQL

2013-08-29 Thread bsreejithin
Ok Igor..Will check out PgBouncer..Thanks a lot. -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-clustering-for-scale-out-works-in-PostgreSQL-tp5768917p5768960.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com. -- Sent via pgsql-perfo

Re: [PERFORM] How clustering for scale out works in PostgreSQL

2013-08-29 Thread bsreejithin
The performance test that was conducted was for 1 Hour. There are 6 transactions. 2 DB inserts and 4 SELECTs. Every 2 minutes there will be 4 SELECTs. And every 3 minutes there will be 2 DB inserts. -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-clustering-for-sc

Re: [PERFORM] How clustering for scale out works in PostgreSQL

2013-08-29 Thread bsreejithin
Thanks a lot Joshua and others who have responded.. I am sorry about not putting in more details in my initial post. What I posted is about a new setup that's going to come up..Discussions are on whether to setup DB cluster to handle 1000 concurrent users. DB cluster was thought of because of th

[PERFORM] How clustering for scale out works in PostgreSQL

2013-08-29 Thread bsreejithin
I am *expecting 1000+ hits to my PostgreSQL DB* and I doubt my standalone DB will be able to handle it. So I want to *scale out by adding more servers to share the load*. For this, I want to do clustering. I am *curious to know how clustering works in PostgreSQL.* (I don't want to know how to se