Re: posix_fadvsise in base backups - Mailing list pgsql-hackers

From Andres Freund
Subject Re: posix_fadvsise in base backups
Date
Msg-id 201109241714.07173.andres@anarazel.de
Whole thread Raw
In response to posix_fadvsise in base backups  (Magnus Hagander <magnus@hagander.net>)
Responses Re: posix_fadvsise in base backups
List pgsql-hackers
Hi,

On Saturday, September 24, 2011 05:08:17 PM Magnus Hagander wrote:
> Attached patch adds a simple call to posix_fadvise with
> POSIX_FADV_DONTNEED on all the files being read when doing a base
> backup, to help the kernel not to trash the filesystem cache.
> 
> Seems like a simple enough fix - in fact, I don't remember why I took
> it out of the original patch :O
> 
> Any reason not to put this in? Is it even safe enough to put into 9.1
> (probably not, but maybe?)
Won't that possibly throw a formerly fully cached database out of the cache?

Andres


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: posix_fadvsise in base backups
Next
From: Magnus Hagander
Date:
Subject: Re: posix_fadvsise in base backups