> -----Original Message----- > From: [email protected] [mailto:pgsql- > [email protected]] On Behalf Of bsreejithin > Sent: Thursday, August 29, 2013 12:42 PM > To: [email protected] > Subject: Re: [PERFORM] How clustering for scale out works in PostgreSQL > > 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-scale-out- > works-in-PostgreSQL-tp5768917p5768957.html > Sent from the PostgreSQL - performance mailing list archive at Nabble.com. > >
With that kind of activity, you don't need clustering for your 1000 users. What you need is PgBouncer, it should solv your problem. Please read some docs on PgBouncer, it's "light-weight" and very easy to setup. Regards, Igor Neyman -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
