Re: Free WAL caches on switching segments

Поиск
Список
Период
Сортировка
Искать
От
ITAGAKI Takahiro
Тема
Re: Free WAL caches on switching segments
Дата
Msg-id
20050830162950.4A5E.ITAGAKI.TAKAHIRO@lab.ntt.co.jp
Ответ на
Список
Дерево обсуждения
Free WAL caches on switching segments ITAGAKI Takahiro <itagaki.takahiro@lab.ntt.co.jp>
Re: Free WAL caches on switching segments Tom Lane <tgl@sss.pgh.pa.us>
Re: Free WAL caches on switching segments ITAGAKI Takahiro <itagaki.takahiro@lab.ntt.co.jp>
Re: Free WAL caches on switching segments Bruce Momjian <pgman@candle.pha.pa.us>
Re: Free WAL caches on switching segments ITAGAKI Takahiro <itagaki.takahiro@lab.ntt.co.jp>
Re: Free WAL caches on switching segments Bruce Momjian <pgman@candle.pha.pa.us>
Re: Free WAL caches on switching segments ITAGAKI Takahiro <itagaki.takahiro@lab.ntt.co.jp>
Re: Free WAL caches on switching segments Bruce Momjian <pgman@candle.pha.pa.us>
Re: Free WAL caches on switching segments Tom Lane <tgl@sss.pgh.pa.us>
Re: Free WAL caches on switching segments Bruce Momjian <pgman@candle.pha.pa.us>
Re: Free WAL caches on switching segments Tom Lane <tgl@sss.pgh.pa.us>
Re: Free WAL caches on switching segments Bruce Momjian <pgman@candle.pha.pa.us>
Re: Free WAL caches on switching segments Tom Lane <tgl@sss.pgh.pa.us>
Re: Free WAL caches on switching segments Bruce Momjian <pgman@candle.pha.pa.us>
Re: Free WAL caches on switching segments Tom Lane <tgl@sss.pgh.pa.us>
Re: Free WAL caches on switching segments Bruce Momjian <pgman@candle.pha.pa.us>
Re: Free WAL caches on switching segments daveg <daveg@sonic.net>
Re: Free WAL caches on switching segments Bruce Momjian <pgman@candle.pha.pa.us>
Re: Free WAL caches on switching segments Tom Lane <tgl@sss.pgh.pa.us>
Re: Free WAL caches on switching segments Simon Riggs <simon@2ndquadrant.com>
Re: Free WAL caches on switching segments Simon Riggs <simon@2ndquadrant.com>
Re: Free WAL caches on switching segments Tom Lane <tgl@sss.pgh.pa.us>
Re: Free WAL caches on switching segments Mark Kirkwood <markir@paradise.net.nz>
Re: Free WAL caches on switching segments Tom Lane <tgl@sss.pgh.pa.us>
Re: Free WAL caches on switching segments Mark Kirkwood <markir@paradise.net.nz>
Re: Free WAL caches on switching segments Tom Lane <tgl@sss.pgh.pa.us>
Re: Free WAL caches on switching segments Bruce Momjian <pgman@candle.pha.pa.us>
Re: Free WAL caches on switching segments Mark Kirkwood <markir@paradise.net.nz>
Re: Free WAL caches on switching segments Bruce Momjian <pgman@candle.pha.pa.us>
Re: Free WAL caches on switching segments Bruce Momjian <pgman@candle.pha.pa.us>
Re: Free WAL caches on switching segments Bruce Momjian <pgman@candle.pha.pa.us>
Tom Lane  wrote:

> > Here is a small patch to prevent undesired WAL file caching by kernel.
> > posix_fadvise(POSIX_FADV_DONTNEED) attempts to free cached pages and
> > the kernel will discard them in preference to other data caches.
> 
> On plenty of platforms, this won't even compile ...


Do you mean simply following code? or more pretty way?

#ifdef POSIX_FADV_DONTNEED
	posix_fadvise(openLogFile, 0, 0, POSIX_FADV_DONTNEED);
#endif


---
ITAGAKI Takahiro
NTT Cyber Space Laboratories


В списке pgsql-patches по дате отправления
От: Tom Lane
Дата:
От: Bruce Momjian
Дата:
FAQ