| From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
|---|---|
| To: | Peter Newman <Peter(dot)Newman(at)iop(dot)org> |
| Cc: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [pgadmin-support] 100% CPU |
| Date: | 2006-07-02 06:25:56 |
| Message-ID: | 44A766F4.8040606@paradise.net.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-performance |
Jim C. Nasby wrote:
> 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.
>>
This could be a good sign! - if you are using COPY into a table with no
indexes and your machine has a good IO subsystem, then typically cpu
becomes the limiting factor. However as Jim suggested, more details
would be good, otherwise we are just guessing!
Cheers
Mark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2006-07-02 07:54:00 | Re: Feature Requests |
| Previous Message | Adam Rich | 2006-07-01 22:26:24 | Feature Requests |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2006-07-02 14:36:20 | Re: FWD: Update touches unrelated indexes? |
| Previous Message | Jim C. Nasby | 2006-06-30 17:58:35 | Re: 100% CPU |