Re: [PATCHES] O_DIRECT for WAL writes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PATCHES] O_DIRECT for WAL writes
Дата
Msg-id 455.1119499219@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PATCHES] O_DIRECT for WAL writes  (Curt Sampson <cjs@cynic.net>)
Ответы Re: [PATCHES] O_DIRECT for WAL writes  (Gavin Sherry <swm@linuxworld.com.au>)
Список pgsql-hackers
[ on the other point... ]

Curt Sampson <cjs@cynic.net> writes:
> But is it really a problem? I somewhere got the impression that some
> drives, on power failure, will be able to keep going for long enough to
> write out the cache and park the heads anyway. If so, the drive is still
> guaranteeing the write.

If the drives worked that way, we'd not be seeing any problem, but we do
see problems.  Without having a whole lot of data to back it up, I would
think that keeping the platter spinning is no problem (sheer rotational
inertia) but seeking to a lot of new tracks to write randomly-positioned
dirty sectors would require significant energy that just ain't there
once the power drops.  I seem to recall reading that the seek actuators
eat the largest share of power in a running drive...
        regards, tom lane


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

Предыдущее
От: Curt Sampson
Дата:
Сообщение: Re: [PATCHES] O_DIRECT for WAL writes
Следующее
От: Alvaro Herrera
Дата:
Сообщение: HaveNFreeProcs ?