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

Re: posix_fadvsise in base backups

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Magnus Hagander <magnus(at)hagander(dot)net>
Subject: Re: posix_fadvsise in base backups
Date: 2011-09-24 15:14:06
Message-ID: 201109241714.07173.andres@anarazel.de (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-hackers by date

Next:From: Magnus HaganderDate: 2011-09-24 15:16:48
Subject: Re: posix_fadvsise in base backups
Previous:From: Magnus HaganderDate: 2011-09-24 15:08:17
Subject: posix_fadvsise in base backups

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