Re: How clustering for scale out works in PostgreSQL

> -----Original Message-----
> From: pgsql-performance-owner(at)postgresql(dot)org [mailto:pgsql-
> performance-owner(at)postgresql(dot)org] On Behalf Of bsreejithin
> Sent: Thursday, August 29, 2013 12:42 PM
> To: pgsql-performance(at)postgresql(dot)org
> 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