Re: iowait

From: Tom Allison <tallison(at)tacocat(dot)net>
To: Alan Hodgson <ahodgson(at)simkin(dot)ca>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: iowait
Date: 2006-06-10 00:08:09
Message-ID: 448A0D69.4030202@tacocat.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Alan Hodgson wrote:
> On Friday 09 June 2006 16:44, Tom Allison <tallison(at)tacocat(dot)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....

In response to

  • Re: iowait at 2006-06-10 00:02:38 from Alan Hodgson

Browse pgsql-novice by date

  From Date Subject
Next Message roy simkes 2006-06-10 08:28:58 Scheduled tasks
Previous Message Alan Hodgson 2006-06-10 00:02:38 Re: iowait