| From: | Manfred Spraul <manfred(at)colorfullife(dot)com> |
|---|---|
| To: | Neil Conway <neilc(at)samurai(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Hannu Krosing <hannu(at)tm(dot)ee>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: adding support for posix_fadvise() |
| Date: | 2003-11-03 19:24:59 |
| Message-ID: | 3FA6AB8B.8060902@colorfullife.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Neil Conway wrote:
>The present Linux implementation doesn't do this, AFAICS -- all it does
>it increase the readahead for this file:
>
>
AFAIK Linux uses a modified LRU that automatically puts pages that were
touched only once at a lower priority than frequently accessed pages.
Neil: what about calling posix_fadvise for the whole file immediately
after issue_xlog_fsync() in XLogWrite? According to the comment, it's
guaranteed that this will happen only once.
Or: add an posix_fadvise into issue_xlog_fsync(), for the range just
sync'ed.
Btw, how much xlog traffic does a busy postgres site generate?
--
Manfred
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2003-11-03 19:25:23 | Re: RC1 on AIX - working thus far |
| Previous Message | Neil Conway | 2003-11-03 18:46:46 | Re: adding support for posix_fadvise() |