Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id DFC2EF64990
	for <pgsql-performance@postgresql.org>;
	Tue, 24 Jul 2012 15:36:35 -0300 (ADT)
Received: from mail.kickstone.com ([46.37.63.75])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <john.lister@kickstone.com>) id 1StjyC-0000T8-Sc
	for pgsql-performance@postgresql.org; Tue, 24 Jul 2012 18:36:34 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
	d=kickstone.com; s=mail;
	h=Content-Transfer-Encoding:Content-Type:In-Reply-To:References:Subject:To:MIME-Version:From:Date:Message-ID;
	bh=Nxs5KLuAAgLHp3MJ22urNffrxtEoeuZXMoloTPRRPF4=;
	b=zasIQPklPICa5q84IQMmROUAJkZRHBiv39JeGzXzDfgg6IP4h0qbF8bAyfmvmbYkCVUsZrJTzbSXicfiWTVG270gbClq4YCh5KjhArkmus/knIIZmOGHE/anacqlOsVY;
Received: from gw1-york.kickstone.com ([46.37.63.73]:58142
	helo=[192.168.2.133]) by mail.kickstone.com with esmtpa (Exim 4.76)
	(envelope-from <john.lister@kickstone.com>) id 1Stjxz-000690-26
	for pgsql-performance@postgresql.org; Tue, 24 Jul 2012 19:36:19 +0100
Message-ID: <500EEB29.3030503@kickstone.com>
Date: Tue, 24 Jul 2012 19:36:25 +0100
From: John Lister <john.lister@kickstone.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Linux memory zone reclaim
References: <500616CB.3070408@2ndQuadrant.com>
In-Reply-To: <500616CB.3070408@2ndQuadrant.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.0 (--)
X-Archive-Number: 201207/310
X-Sequence-Number: 47491

On Tue, Jul 18, 2012 at 2:38 AM, Claudio Freire wrote:
 >It must have been said already, but I'll repeat it just in case:

 >I think postgres has an easy solution. Spawn the postmaster with
 >"interleave", to allocate shared memory, and then switch to "local" on
 >the backends.

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?

Thanks