DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=iOg+6wN6B8Wpani3LOHz7ioBQoC46VL2KcDJ+AWSfCX4umK0a/iZfOae8NyY0FkDC2
	1VwlVYDxLxBEu5Ipm8YJm1IXgwUHLrchW8p39/PK7zE1hsOsZaoYcT1mLdVY3zCg4mkh
	Q94sA9kwPoNVrND75RRJygPW5atu0VpjR0vgY=
Message-ID: <b42b73150901060916w11982ba3pb10ccd7de30178ad@mail.gmail.com>
Date: Tue, 6 Jan 2009 12:16:46 -0500
From: "Merlin Moncure" <mmoncure@gmail.com>
To: "Stefano Nichele" <stefano.nichele@gmail.com>
Subject: Re: understanding postgres issues/bottlenecks
Cc: pgsql-performance@postgresql.org
In-Reply-To: <49638BE9.2030701@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <49638BE9.2030701@gmail.com>

On Tue, Jan 6, 2009 at 11:50 AM, Stefano Nichele
<stefano.nichele@gmail.com> wrote:
> Hi list,
> I would like to ask your help in order to understand if my postgresql server
> (ver. 8.2.9) is well configured.
> It's a quad-proc system (32 bit) with a 6 disk 1+0 RAID array and 2 separate
> disks for the OS and write-ahead logs with 4GB of RAM.
>
> I don't know what is the best info to help me and so I start with some
> vmstat information:
>
>> vmstat -n 30
> procs -----------memory---------- ---swap-- -----io---- --system--
> -----cpu------
> r  b   swpd   free   buff  cache   si   so    bi    bo   in   cs us sy id wa
> st
> 0 23     84 129968  25060 3247860    0    0    78    50    0    2 17  5 33
> 45  0

clearly i/o bound. can you throw an iostat to give some more detailed info?
also,
need o/s version, etc
disk info (speed, raid controller, etc)
my guess is your disk system is underpowered for transaction load you
are giving.
how many tps is the database doing?

merlin