Re: Experimental patch for inter-page delay in VACUUM

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB SD
Тема Re: Experimental patch for inter-page delay in VACUUM
Дата
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA4962059@m0114.s-mxs.net
обсуждение исходный текст
Ответ на Experimental patch for inter-page delay in VACUUM  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> > The only idea I have come up with is to move all buffer write operations
> > into a background writer process, which could easily keep track of
> > every file it's written into since the last checkpoint.
>
> I fear this approach. It seems to limit a lot of design flexibility later. But
> I can't come up with any concrete way it limits things so perhaps that
> instinct is just fud.

A lot of modern disk subsystems can only be saturated with more then one parallel
IO request. So it would at least need a tuneable number of parallel writer processes,
or one writer that uses AIO to dump all outstanding IO requests out at once.
(Optimal would be all, in reality it would need to be batched into groups of
n pages, since most systems have a max aio request queue size, e.g. 8192).

Andreas


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: \xDD patch for 7.5devel
Следующее
От: "Zeugswetter Andreas SB SD"
Дата:
Сообщение: Re: Experimental ARC implementation