Re: "iowait" bug?

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: "iowait" bug?
Дата
Msg-id alpine.GSO.2.01.0903222356240.7558@westnet.com
обсуждение исходный текст
Ответ на Re: "iowait" bug?  (Laurent Wandrebeck <l.wandrebeck@gmail.com>)
Список pgsql-performance
On Mon, 23 Mar 2009, Laurent Wandrebeck wrote:

> I thought about completely fair scheduler at first, but that one came
> in around 2.6.21.

CFS showed up in 2.6.23.

> I think that forcing the system to write down more often, and smaller
> data just hides the problem, and doesn't correct it.

That's one possibility.  I've been considering things like whether the OS
is getting bogged down managing things like the elevator sorting for
outstanding writes.  If there was something about that process that gets
really inefficient proportionally to the size of the pending queue, that
would both match the kinds of symptoms people are reporting, and would go
better just reducing the maximum size of the issue by lowering the pdflush
tunables.

Anyway, the point I was trying to make is that there sure seem to be
multiple problems mixed into that one bug report, and it's starting to
look just as unmanagably messy as the older bug that had to be abandoned.
It would have been nice if somebody kicked out all the diversions it
wanted into to keep the focus a bit better.  Anybody using a SSD device,
USB, or ext4 should have been punted to somewhere else for example.
Plenty of examples that don't require any of those things.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: LIMIT confuses the planner
Следующее
От: Romuald Brunet
Дата:
Сообщение: Slower query after psql changed it's execution plan