X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 83699475ADE for ; Fri, 21 Feb 2003 10:53:19 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 09602-03 for ; Fri, 21 Feb 2003 10:53:09 -0500 (EST) Received: from www.pspl.co.in (www.pspl.co.in [202.54.11.65]) by postgresql.org (Postfix) with ESMTP id 70E6147580B for ; Fri, 21 Feb 2003 10:51:12 -0500 (EST) Received: (from root@localhost) by www.pspl.co.in (8.11.6/8.11.6) id h1LFpHG07621 for ; Fri, 21 Feb 2003 21:21:17 +0530 Received: from daithan.intranet.pspl.co.in (daithan.intranet.pspl.co.in [192.168.7.161]) by www.pspl.co.in (8.11.6/8.11.0) with ESMTP id h1LFpGt07616 for ; Fri, 21 Feb 2003 21:21:17 +0530 From: "Shridhar Daithankar" To: pgsql-performance@postgresql.org Subject: Re: Really bad insert performance: what did I do wrong? Date: Fri, 21 Feb 2003 21:21:55 +0530 User-Agent: KMail/1.5 References: <3E564695.7030906@digital-ics.com> In-Reply-To: <3E564695.7030906@digital-ics.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200302212121.55483.shridhar_daithankar@persistent.co.in> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/154 X-Sequence-Number: 1210 On Friday 21 Feb 2003 9:02 pm, you wrote: > Any thoughts? I know that postgres should be more than capable of > loading this data quickly on this box...I figured it could possibly take > twice as long...and I thought my problem would be i/o related, not CPU. First, check vmstat or similar on SunOS. See what is maxing out. Second tunr postgresql trace on and see where it is specnding most of the CPU. Needless to say, did you tune shared buffers? Shridhar