Re: Linux kernel impact on PostgreSQL performance - Mailing list pgsql-hackers

From Claudio Freire
Subject Re: Linux kernel impact on PostgreSQL performance
Date
Msg-id CAGTBQpakKH+LCPHS7tHWsgjT_rxHaxQ4thYx6ZiYpCJQQVtYgg@mail.gmail.com
Whole thread Raw
In response to Re: Linux kernel impact on PostgreSQL performance  (Mel Gorman <mgorman@suse.de>)
List pgsql-hackers
On Mon, Jan 13, 2014 at 7:36 PM, Mel Gorman <mgorman@suse.de> wrote:
> That could be something we look at. There are cases buried deep in the
> VM where pages get shuffled to the end of the LRU and get tagged for
> reclaim as soon as possible. Maybe you need access to something like
> that via posix_fadvise to say "reclaim this page if you need memory but
> leave it resident if there is no memory pressure" or something similar.
> Not exactly sure what that interface would look like or offhand how it
> could be reliably implemented.


I don't see a reason not to make this behavior the default for WONTNEED.



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: plpgsql.consistent_into
Next
From: Jim Nasby
Date:
Subject: Re: Disallow arrays with non-standard lower bounds