Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 352D99FB1FE
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 29 Sep 2006 06:12:45 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 94597-05 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 29 Sep 2006 06:12:36 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from webmail.enterprisedb.com (edb04.managed.contegix.com
	[63.246.7.176]) by postgresql.org (Postfix) with ESMTP id B606F9FB1FB
	for <pgsql-performance@postgresql.org>;
	Fri, 29 Sep 2006 06:12:36 -0300 (ADT)
Received: from [192.168.0.20] (unknown [62.232.55.86])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(Client did not present a certificate)
	by webmail.enterprisedb.com (Postfix) with ESMTP id 38DE2A24A83;
	Fri, 29 Sep 2006 04:12:35 -0500 (CDT)
Message-ID: <451CE38B.7070107@enterprisedb.com>
Date: Fri, 29 Sep 2006 10:12:43 +0100
From: Heikki Linnakangas <heikki@enterprisedb.com>
User-Agent: Thunderbird 1.5.0.5 (X11/20060812)
MIME-Version: 1.0
To: Carlo Stonebanks <stonec.register@sympatico.ca>
CC: pgsql-performance@postgresql.org
Subject: Re: Performace Optimization for Dummies
References: <efgu4v$276m$1@news.hub.org>
In-Reply-To: <efgu4v$276m$1@news.hub.org>
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.201 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200609/420
X-Sequence-Number: 21106

Carlo Stonebanks wrote:
> We urgently need a major performance improvement. We are running the
> PostgreSQL 8.1.4 on a Windows 2003 x64 Server on a dual processor, 
> dual core
> 3.2Ghz Xeon box with 4gb RAM and a RAID (sorry, I don't know what 
> type) disc
> subsystem. Sorry about the long intro, but here are my questions:

Others have already drilled down to the way you do the inserts and 
statistics etc., so I'll just point out:

Are you fully utilizing all the 4 cores you have? Could you parallelize 
the loading process, if you're currently running just one client? Are 
you I/O bound or CPU bound?

-- 
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com