Re: [PERFORM] Server Configuration

2011-02-02 Thread Marcos Ortiz
On Wed, 2011-02-02 at 15:15 -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

Re: [PERFORM] Server Configuration

2011-02-02 Thread Richard Carnes
I would personally highly recommend using pgBouncer! I have been using this in production migrating from MySQL and have had phenomenal success with it combined with lighttpd and php as an internal information system. I am getting on average 300 requests per second very low load average as it is m

Re: [PERFORM] Server Configuration

2011-02-02 Thread Kenneth Marshall
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 w

[PERFORM] Server Configuration

2011-02-02 Thread Cesar Arrieta
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