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
