pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed100% CPU
3+ messages / 3 participants
[nested] [flat]
* 100% CPU
@ 2006-06-30 07:32 Peter Newman <Peter.Newman@iop.org>
0 siblings, 1 reply; 3+ messages in thread
From: Peter Newman @ 2006-06-30 07:32 UTC (permalink / raw)
To: pgadmin-support@postgresql.org
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.
Thank you
Pete Newman
Information Systems
Institute of Physics
Tel No 0117 9301249
Fax No 0117 9301183
Peter.Newman@iop.org
http://www.iop.org
<p>
************************************************************************<p>
This email (and attachments) are confidential and intended for the addressee(s) only. If you are not the intended recipient please notify the sender, delete any copies and do not take action in reliance on it. Any views expressed are the author's and do not represent those of IOP, except where specifically stated. IOP takes reasonable precautions to protect against viruses but accepts no responsibility for loss or damage arising from virus infection. For the protection of IOP's systems and staff emails are scanned automatically.<p>
IOP Publishing Limited Registered in England under Registration No 467514. Registered Office: Dirac House, Temple Back, Bristol BS1 6BE England
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: 100% CPU
@ 2006-06-30 17:58 Jim C. Nasby <jnasby@pervasive.com>
parent: Peter Newman <Peter.Newman@iop.org>
0 siblings, 1 reply; 3+ messages in thread
From: Jim C. Nasby @ 2006-06-30 17:58 UTC (permalink / raw)
To: Peter Newman <Peter.Newman@iop.org>; +Cc: 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@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [pgadmin-support] 100% CPU
@ 2006-07-02 06:25 Mark Kirkwood <markir@paradise.net.nz>
parent: Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 0 replies; 3+ messages in thread
From: Mark Kirkwood @ 2006-07-02 06:25 UTC (permalink / raw)
To: Peter Newman <Peter.Newman@iop.org>; +Cc: Jim C. Nasby <jnasby@pervasive.com>; 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-07-02 06:25 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-06-30 07:32 100% CPU Peter Newman <Peter.Newman@iop.org>
2006-06-30 17:58 ` Jim C. Nasby <jnasby@pervasive.com>
2006-07-02 06:25 ` Mark Kirkwood <markir@paradise.net.nz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox