Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 88B1D2E004B for ; Tue, 17 Jun 2008 18:15:28 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 91515-01 for ; Tue, 17 Jun 2008 18:15:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from westnet.com (westnet.com [216.187.52.2]) by developer.postgresql.org (Postfix) with ESMTP id C84992E003C for ; Tue, 17 Jun 2008 18:15:16 -0300 (ADT) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id m5HLFErY011816; Tue, 17 Jun 2008 17:15:14 -0400 (EDT) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id m5HLFE5m011813; Tue, 17 Jun 2008 17:15:14 -0400 (EDT) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Tue, 17 Jun 2008 17:15:14 -0400 (EDT) From: Greg Smith X-X-Sender: gsmith@westnet.com To: Lionel cc: pgsql-performance@postgresql.org Subject: Re: Which hardware ? In-Reply-To: Message-ID: References: <20080617142501.GG68434@commandprompt.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/88 X-Sequence-Number: 30438 On Tue, 17 Jun 2008, Lionel wrote: > I did some test with a 20 millions lines database on a single disk dual core > 2GB win XP system (default postgresql config), most of the time is spent in > I/O: 50-100 secs for statements that scan 6 millions of lines, which will > happen. Almost no CPU activity. I hope you're aware that the default config is awful, and there are all sorts of possible causes for heavy I/O churn that might improve if you setup the postgresql.conf file to use the server's resources more aggressively (the default is setup for machines with a very small amount of RAM). There are lots of links to articles that cover the various areas you might improve at http://wiki.postgresql.org/wiki/Performance_Optimization -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD