Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 8A0012E01EB for ; Tue, 4 Mar 2008 17:03:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 92398-02 for ; Tue, 4 Mar 2008 17:03:09 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from skynet.simkin.ca (skynet.simkin.ca [72.51.27.117]) by postgresql.org (Postfix) with ESMTP id 236DB2E0088 for ; Tue, 4 Mar 2008 17:03:13 -0400 (AST) Received: from charon.medialogik.com (charon.medialogik.com [72.51.27.114]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by skynet.simkin.ca (Postfix) with ESMTP id 07A1C4714 for ; Tue, 4 Mar 2008 13:03:11 -0800 (PST) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-performance@postgresql.org Subject: Re: Optimisation help Date: Tue, 4 Mar 2008 13:03:58 -0800 User-Agent: KMail/1.9.6 (enterprise 0.20070907.709405) References: <47CDCB62.9070302@vieonet.com> In-Reply-To: <47CDCB62.9070302@vieonet.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200803041303.58321@hal.medialogik.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/59 X-Sequence-Number: 29013 On Tuesday 04 March 2008, dforums wrote: > Hello > > > We hace a Quad Xeon server, with 8GO of ram, sata II 750Go > > > I suppose the main problem is from database server settings. No, the problem is your hard drive is too slow. One drive can only do maybe 150 seeks per second. Oh, and updates in PostgreSQL are expensive. But mostly I'd say it's your drive. -- Alan