| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Röttgerding | 2006-07-01 11:31:43 | Error Message: ERROR: column "datpath" does not exist |
| Previous Message | Dave Page | 2006-06-30 08:05:21 | Re: pgagent status always successful |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Kirkwood | 2006-07-02 06:25:56 | Re: [pgadmin-support] 100% CPU |
| Previous Message | Alvaro Herrera | 2006-06-30 17:27:49 | Re: FWD: Update touches unrelated indexes? |