Re: iowait

Поиск
Список
Период
Сортировка
От Tom Allison
Тема Re: iowait
Дата
Msg-id 448A0D69.4030202@tacocat.net
обсуждение исходный текст
Ответ на Re: iowait  (Alan Hodgson <ahodgson@simkin.ca>)
Список 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 по дате отправления:

Предыдущее
От: Alan Hodgson
Дата:
Сообщение: Re: iowait
Следующее
От: "roy simkes"
Дата:
Сообщение: Scheduled tasks