Re: Experimental patch for inter-page delay in VACUUM

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB SD
Тема Re: Experimental patch for inter-page delay in VACUUM
Дата
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA4962060@m0114.s-mxs.net
обсуждение исходный текст
Ответ на Experimental patch for inter-page delay in VACUUM  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Experimental patch for inter-page delay in VACUUM
Список pgsql-hackers
> > One problem with O_SYNC would be, that the OS does not group writes any
> > more. So the code would need to eighter do it's own sorting and grouping
> > (256k) or use aio, or you won't be able to get the maximum out of the disks.
>
> Or just run multiple writer processes, which I believe is Oracle's
> solution.

That does not help, since for O_SYNC the OS'es (those I know) do not group those
writes together. Oracle allows more than one writer to busy more than one disk(subsystem) and circumvent other per
processlimitations (mainly on platforms without AIO).  

Andreas


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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: Experimental patch for inter-page delay in VACUUM
Следующее
От:
Дата:
Сообщение: Catching "UPDATE 0"