From: Stefano Nichele <stefano.nichele@gmail.com>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: understanding postgres issues/bottlenecks
Date: Tue, 06 Jan 2009 20:02:39 +0100
Message-ID: <4963AACF.2070201@gmail.com> (raw)
In-Reply-To: <b42b73150901060916w11982ba3pb10ccd7de30178ad@mail.gmail.com>
References: <49638BE9.2030701@gmail.com>
<b42b73150901060916w11982ba3pb10ccd7de30178ad@mail.gmail.com>
Thanks for your help. I'll give you the info you asked as soon as I'll
have it (i have also to install iostat but I don't have enough privilege
to do that).
BTW, why did you said I/O bound ? Which are the parameters that
highlight that ? Sorry for my ignorance....
ste
Merlin Moncure wrote:
> 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
>
>
--
Stefano Nichele
Funambol Chief Architect
Funambol :: Open Source Mobile'We' for the Mass Market :: http://www.funambol.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: stefano.nichele@gmail.com, mmoncure@gmail.com
Subject: Re: understanding postgres issues/bottlenecks
In-Reply-To: <4963AACF.2070201@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox