Re: iowait - Mailing list pgsql-novice

From Tom Allison
Subject Re: iowait
Date
Msg-id 448A0D69.4030202@tacocat.net
Whole thread Raw
In response to Re: iowait  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-novice
Alan Hodgson wrote:
> On Friday 09 June 2006 16:44, Tom Allison <tallison@tacocat.net> wrote:
> Default values aren't really a factor.  The index slows down COPY some.  The
> reason it's slow is your hard drive, though.
>

That's what I was starting to think.

I can run individual transactions fine and handle concurrent threads up to ~100
as long as the transactions are simple (eg: index keyed SQL, no full table scans).

But anytime I try to do aggregate or large blocks of operations....


pgsql-novice by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: iowait
Next
From: "roy simkes"
Date:
Subject: Scheduled tasks