Skip site navigation (1) Skip section navigation (2)

Re: adding support for posix_fadvise()

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 (view raw or flat)
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

In response to

Responses

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2003-11-03 19:25:23
Subject: Re: RC1 on AIX - working thus far
Previous:From: Neil ConwayDate: 2003-11-03 18:46:46
Subject: Re: adding support for posix_fadvise()

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group