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