Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id D335111F9D75 for ; Thu, 26 Jul 2012 21:26:09 -0300 (ADT) Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SuYNb-0004Sb-R1 for pgsql-performance@postgresql.org; Fri, 27 Jul 2012 00:26:09 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1SuYNO-0005n8-Kr; Thu, 26 Jul 2012 20:25:54 -0400 Date: Thu, 26 Jul 2012 20:25:54 -0400 From: Bruce Momjian To: Greg Smith Cc: pgsql-performance@postgresql.org Subject: Re: Linux memory zone reclaim Message-ID: <20120727002554.GC24238@momjian.us> References: <500616CB.3070408@2ndQuadrant.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <500616CB.3070408@2ndQuadrant.com> User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201207/343 X-Sequence-Number: 47524 On Tue, Jul 17, 2012 at 09:52:11PM -0400, Greg Smith wrote: > I've taken to disabling /proc/sys/vm/zone_reclaim_mode on any Linux > system where it's turned on now. I'm still working through whether -------------------------------- > it also makes sense in all cases to use the more complicated memory > interleaving suggestions that MySQL users have implemented, > something most people would need to push into their PostgreSQL > server started up scripts in /etc/init.d (That will be a fun > rpm/deb packaging issue to deal with if this becomes more > wide-spread) Suggestions on whether that is necessary, or if just > disabling zone_reclaim is enough, are welcome from anyone who wants > to try and benchmark it. Should I be turning it off on my server too? It is enabled on my system. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +