Re: Compression and on-disk sorting

Поиск
Список
Период
Сортировка
От Florian Weimer
Тема Re: Compression and on-disk sorting
Дата
Msg-id 87ac9fuc6s.fsf@mid.deneb.enyo.de
обсуждение исходный текст
Ответ на Re: Compression and on-disk sorting  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-hackers
* Jim C. Nasby:

> The problem is that it seems like there's never enough ability to clue
> the OS in on what the application is trying to accomplish. For a long
> time we didn't have a background writer, because the OS should be able
> to flush things out on it's own before checkpoint. Now there's talk of a
> background reader, because backends keep stalling on waiting on disk IO.

I've recently seen this on one of our test systems -- neither CPU nor
disk I/O were maxed out.

Have you considered using asynchronous I/O?  Maybe it results in less
complexity and fewer context switches than a background reader.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Florian Weimer
Дата:
Сообщение: Re: [OT] MySQL is bad, but THIS bad?
Следующее
От: Florian Weimer
Дата:
Сообщение: Re: PL/pgSQL 'i = i + 1' Syntax