Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 3AE479FB2F4 for ; Mon, 2 Oct 2006 23:44:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 18567-04 for ; Tue, 3 Oct 2006 02:43:59 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 36BA29FB2AA for ; Mon, 2 Oct 2006 23:43:59 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id F3EFA30E1A; Tue, 3 Oct 2006 04:43:56 +0200 (MET DST) From: "Carlo Stonebanks" X-Newsgroups: pgsql.performance Subject: Re: Performace Optimization for Dummies Date: Mon, 2 Oct 2006 22:43:46 -0400 Organization: Hub.Org Networking Services Lines: 31 Message-ID: References: <451CE38B.7070107@enterprisedb.com> X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-RFC2646: Format=Flowed; Response To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200610/16 X-Sequence-Number: 21145 I have loaded three of the four cores by running three different versions of the import program to import three different segments of the table to import. The server jumps to 75% usage, with three postgresql processes eating up 25% each., the actual client itself taking up just a few ticks. "Heikki Linnakangas" wrote in message news:451CE38B.7070107@enterprisedb.com... > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster >