Skip site navigation (1) Skip section navigation (2)

Re: 100% CPU

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Peter Newman <Peter(dot)Newman(at)iop(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 100% CPU
Date: 2006-06-30 17:58:35
Message-ID: 20060630175834.GH17241@pervasive.com (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-performance
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(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

In response to

  • 100% CPU at 2006-06-30 07:32:39 from Peter Newman

Responses

pgsql-performance by date

Next:From: Mark KirkwoodDate: 2006-07-02 06:25:56
Subject: Re: [pgadmin-support] 100% CPU
Previous:From: Alvaro HerreraDate: 2006-06-30 17:27:49
Subject: Re: FWD: Update touches unrelated indexes?

pgadmin-support by date

Next:From: Paul RöttgerdingDate: 2006-07-01 11:31:43
Subject: Error Message: ERROR: column "datpath" does not exist
Previous:From: Dave PageDate: 2006-06-30 08:05:21
Subject: Re: pgagent status always successful

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group