Re: Slow copy with little CPU/disk usage

From: Greg Stark <gsstark(at)mit(dot)edu>
To: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow copy with little CPU/disk usage
Date: 2005-04-20 04:34:27
Message-ID: 87d5sqdq24.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Jim C. Nasby" <decibel(at)decibel(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mischa Sandberg 2005-04-20 04:37:21 Re: Slow copy with little CPU/disk usage
Previous Message Jim C. Nasby 2005-04-20 03:40:41 Re: Sort and index