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

Re: Linux memory zone reclaim

From: John Lister <john(dot)lister(at)kickstone(dot)com>
To: Claudio Freire <klaussfreire(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Linux memory zone reclaim
Date: 2012-07-24 21:23:05
Message-ID: 500F1239.80104@kickstone.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 24/07/2012 21:12, Claudio Freire wrote:
> On Tue, Jul 24, 2012 at 3:41 PM, Claudio Freire <klaussfreire(at)gmail(dot)com> wrote:
>> On Tue, Jul 24, 2012 at 3:36 PM, John Lister <john(dot)lister(at)kickstone(dot)com> wrote:
>>> Do you have a suggestion about how to do that? I'm running Ubuntu 12.04 and
>>> PG 9.1, I've modified pg_ctlcluster to cause pg_ctl to use a wrapper script
>>> which starts the postmaster using a numactl wrapper, but all subsequent
>>> client processes are started with interleaving enabled as well. Any ideas
>>> how to make just the postmaster process start with interleaving?
>> postmaster should call numactl right after forking:
>> http://linux.die.net/man/2/set_mempolicy
> Something like the attached patch (untested)
Cheers, I'll give it a go, I wonder if this is likely to be integrated 
into the main code? As has been mentioned here before, postgresql isn't 
as badly affected as mysql for example, but I'm wondering if the trend 
to larger memory and more cores/nodes means it should be offered as an 
option? Although saying that I've read that 10Gb of shared buffers may 
be enough even in big machines 128+Gb ram..

Thoughts?

John



In response to

Responses

pgsql-performance by date

Next:From: Claudio FreireDate: 2012-07-24 21:37:44
Subject: Re: Linux memory zone reclaim
Previous:From: Claudio FreireDate: 2012-07-24 21:00:01
Subject: Re: Linux memory zone reclaim

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