Re: Slow copy with little CPU/disk usage - Mailing list pgsql-performance

From Greg Stark
Subject Re: Slow copy with little CPU/disk usage
Date
Msg-id 87d5sqdq24.fsf@stark.xeocode.com
Whole thread Raw
In response to Slow copy with little CPU/disk usage  ("Jim C. Nasby" <decibel@decibel.org>)
Responses Re: Slow copy with little CPU/disk usage
List pgsql-performance
"Jim C. Nasby" <decibel@decibel.org> writes:

> What's really odd is that neither the CPU or the disk are being
> hammered. The box appears to be pretty idle; the postgresql proces is
> using 4-5% CPU.

Is he committing every row? In that case you would see fairly low i/o
bandwidth usage because most of the time is being spent seeking and waiting
for rotational latency.

--
greg

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Sort and index
Next
From: Mischa Sandberg
Date:
Subject: Re: Slow copy with little CPU/disk usage