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 servesat most250connections. 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?.