Re: posix_fadvise() and pg_receivexlog

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: posix_fadvise() and pg_receivexlog
Дата
Msg-id 53E27B13.50506@vmware.com
обсуждение исходный текст
Ответ на posix_fadvise() and pg_receivexlog  (Fujii Masao <masao.fujii@gmail.com>)
Ответы Re: posix_fadvise() and pg_receivexlog  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-hackers
On 08/06/2014 08:39 PM, Fujii Masao wrote:
> Hi,
>
> The WAL files that pg_receivexlog writes will not be re-read soon basically,
> so we can advise the OS to release any cached pages when WAL file is
> closed. I feel inclined to change pg_receivexlog that way. Thought?

-1. The OS should be smart enough to not thrash the cache by files that 
are written sequentially and never read. If we go down this path, we'd 
need to sprinkle posix_fadvises into many, many places.

Anyway, who are we to say that they won't be re-read soon? You might e.g 
have a secondary backup site where you copy the files received by 
pg_receivexlog, as soon as they're completed.

- Heikki




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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: posix_fadvise() and pg_receivexlog
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: A worst case for qsort