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
Ответ на
Re: Free WAL caches on switching segments (Tom Lane)
Список
Дерево обсуждения
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 по дате отправления
От: Bruce Momjian
Дата: