Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 277FA632252 for ; Tue, 6 Jan 2009 15:03:03 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 26618-01 for ; Tue, 6 Jan 2009 15:02:57 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from a.mail.sonomait.com (a.mail.sonomait.com [64.142.123.30]) by mail.postgresql.org (Postfix) with ESMTP id 0C58E63217E for ; Tue, 6 Jan 2009 15:02:57 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by a.mail.sonomait.com (Postfix) with ESMTP id D9C32165604; Tue, 6 Jan 2009 11:02:53 -0800 (PST) X-Virus-Scanned: amavisd-new at Received: from a.mail.sonomait.com ([127.0.0.1]) by localhost (a.mail.sonomait.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 9k1YwTjHiwRH; Tue, 6 Jan 2009 11:02:52 -0800 (PST) Received: from [192.168.1.33] (ppp-217-198.20-151.libero.it [151.20.198.217]) by a.mail.sonomait.com (Postfix) with ESMTP id 17F5A1644FE; Tue, 6 Jan 2009 11:02:50 -0800 (PST) Message-ID: <4963AACF.2070201@gmail.com> Date: Tue, 06 Jan 2009 20:02:39 +0100 From: Stefano Nichele User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: Merlin Moncure CC: pgsql-performance@postgresql.org Subject: Re: understanding postgres issues/bottlenecks References: <49638BE9.2030701@gmail.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/16 X-Sequence-Number: 32295 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 > 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