Re: ionice to make vacuum friendier?

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: ionice to make vacuum friendier?
Дата
Msg-id 20070718184816.GB39272@nasby.net
обсуждение исходный текст
Ответ на Re: ionice to make vacuum friendier?  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список pgsql-performance
On Wed, Jul 18, 2007 at 10:03:00AM +0100, Heikki Linnakangas wrote:
> Ron Mayer wrote:
> > Seems Linux has IO scheduling through a program called ionice.
> >
> > Has anyone here experimented with using it rather than
> > vacuum sleep settings?
>
> I looked at that briefly for smoothing checkpoints, but it was
> unsuitable for that purpose because it only prioritizes reads, not writes.
>
> It maybe worth trying for vacuum, though vacuum too can do a lot of
> writes. In the worst case, the OS cache is saturated with dirty pages,
> which blocks all writes in the system.
>
> If it did prioritize writes as well, that would be *excellent*. Any
> kernel hackers out there looking for a project?

My understanding is that FreeBSD will prioritize IO based on process
priority, though I have no idea how it's actually accomplished or how
effective it is. But if we put in special support for this for Linux we
should consider FBSD as well.
--
Jim Nasby                                      decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

Вложения

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

Предыдущее
От: "Steven Flatt"
Дата:
Сообщение: When/if to Reindex
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Parrallel query execution for UNION ALL Queries