Postgres Pro
Downloads
Home   >   mailing lists

Server Configuration - Mailing list pgsql-performance

From Cesar Arrieta
Subject Server Configuration
Date
Msg-id AANLkTinr3QTVSet8GOCJWO0cFD9qfbLpNqw4NvMR4HGt@mail.gmail.com
Whole thread Raw
Responses Re: Server Configuration
Re: Server Configuration
List pgsql-performance
Tree view
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?.

pgsql-performance by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: [HACKERS] Slow count(*) again...
Next
From: Jon Nelson
Date:
Subject: Re: [HACKERS] Slow count(*) again...