X-Original-To: pgadmin-support-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id DEC259FA2A9 for ; Fri, 30 Jun 2006 14:58:43 -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 89766-02 for ; Fri, 30 Jun 2006 14:58:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 639F49FA192 for ; Fri, 30 Jun 2006 14:58:36 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 5A2F056437; Fri, 30 Jun 2006 12:58:35 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Fri, 30 Jun 2006 12:58:35 -0500 Date: Fri, 30 Jun 2006 12:58:35 -0500 From: "Jim C. Nasby" To: Peter Newman Cc: pgsql-performance@postgresql.org Subject: Re: 100% CPU Message-ID: <20060630175834.GH17241@pervasive.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060630:pgadmin-support@postgresql.org::dCSWDFXjzWx1qFLa:0000000 0000000000000000000000000ftF X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/91 X-Sequence-Number: 5573 moving to -performance On Fri, Jun 30, 2006 at 08:32:39AM +0100, Peter Newman wrote: > Good Morning > > I am new to postgres and have been asked to look at a server where we > truncate a table then load data. > > The CPU has started to hit 100% usage during this process. > > Can you please describe what steps I could take to investigate and solve > this issue? > So far all I have done is run a Vacuum Analyze command using PGAdmin > III.....which appears to have made little difference. How many indexes do you have on the table? How exactly are you loading the data? What hardware is this? What version of the database? -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461