Re: posix_fadvise missing in the walsender

Поиск
Список
Период
Сортировка
От Florian Weimer
Тема Re: posix_fadvise missing in the walsender
Дата
Msg-id 871ubyaiwe.fsf@mid.deneb.enyo.de
обсуждение исходный текст
Ответ на Re: posix_fadvise missing in the walsender  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
* Jeff Janes:

> Does the kernel really read a data block from disk into memory in
> order to immediately overwrite it?  I would have thought it would
> optimize that away, at least if the writes are sized and aligned to
> 512 or 1024 bytes blocks (which WAL should be).

With Linux, you'd have to use O_DIRECT to get that effect (but don't
do that), otherwise writes happen in page size granularity, writing in
512 or 1024 byte blocks should really trigger a read-modify-write
cycle.



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: sql_drop Event Trigger
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Memory leakage associated with plperl spi_prepare/spi_freeplan