On Wed, Feb 02, 2011 at 03:15:22PM -0300, Cesar Arrieta wrote: > Hi, I have a Server with Fedora Core 11, Tomcat and Postgresql 8.3. > With Hardware: > * 8GB RAM > * 8 processors Intel Xeon E5520 @2.27GHz > * 250GB SATA DISK > > Actually, it serves at most 250 connections. > The problem happends when it serves many many connections at a time, tables > and queries began to get blocked, then I have to kill some processes > in order to allow other people continue working. > > Wich recommendations could you give me for to configure postgresql.conf, and > could it be eficcient to buy another server with almost same hardware > in order to use pgPool2 with replication, load balance and parallel query?. It sounds like you may just need a connection pooler (pgpool, pgbouncer) and it might work just fine. Cheers, Ken -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
