Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id DE7564BB8E7
	for <pgsql-performance@postgresql.org>;
	Wed,  4 Apr 2012 10:20:59 -0300 (ADT)
Received: from [2001:1528:137::f1] (helo=mail.gransy.com)
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tv@fuzzy.cz>) id 1SFQ8w-0000YX-MZ
	for pgsql-performance@postgresql.org; Wed, 04 Apr 2012 13:20:59 +0000
Received: from antispam.gransy.com (antispam.gransy.com [77.78.104.124])
	by mail.gransy.com (Postfix) with ESMTP id 6CED1508673
	for <pgsql-performance@postgresql.org>;
	Wed,  4 Apr 2012 15:20:46 +0200 (CEST)
Received: from mail.gransy.com ([82.208.29.194])
	by antispam.gransy.com (antispam.gransy.com [77.78.104.124])
	(amavisd-new, port 10024)
	with ESMTP id Tj2e-s-9HuuS for <pgsql-performance@postgresql.org>;
	Wed,  4 Apr 2012 15:20:46 +0200 (CEST)
Received: by mail.gransy.com (Postfix, from userid 5000)
	id 5DC8550888B; Wed,  4 Apr 2012 15:20:46 +0200 (CEST)
Received: from [192.168.1.237] (ip-78-45-133-255.net.upcbroadband.cz
	[78.45.133.255])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.gransy.com (Postfix) with ESMTPSA id 3FC73508673
	for <pgsql-performance@postgresql.org>;
	Wed,  4 Apr 2012 15:20:46 +0200 (CEST)
Message-ID: <4F7C4AAE.4060608@fuzzy.cz>
Date: Wed, 04 Apr 2012 15:20:46 +0200
From: Tomas Vondra <tv@fuzzy.cz>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:11.0) Gecko/20120312 Thunderbird/11.0
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: H800 + md1200 Performance problem
References: 
 <CAMAsR=4acKwYjow-VWQ0xH0+WjXEtVJWxP0A0y4vx=oyr5fhpQ@mail.gmail.com>
	<920BB532-C321-45A3-851E-8B688A5963F7@yahoo.com>
	<CAMAsR=7g5PXU45+Z3aBW+ur-kPQKiW2MG=NJ3TOqNn6iqaVCVw@mail.gmail.com>
	<4F7AF966.20809@fuzzy.cz>
	<CAMAsR=637=zAtOSxGF=JH9apfOtU7FaUXR27+J2syzE_c-rdYw@mail.gmail.com>
	<4F7B3AEC.4000204@fuzzy.cz>
	<CAMAsR=7onjeWr--PtgHgfZv=yYSB8FVxf1BsYSwu2752YY0Q8w@mail.gmail.com>
	<CAOR=d=036JkSF9743YBBLF3avOSqOs4niadGR0UDu6Ji5ba5xw@mail.gmail.com>
In-Reply-To: 
 <CAOR=d=036JkSF9743YBBLF3avOSqOs4niadGR0UDu6Ji5ba5xw@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Host-Lookup-Failed: Reverse DNS lookup failed for 2001:1528:137::f1 (failed)
X-Pg-Spam-Score: -1.1 (-)
X-Archive-Number: 201204/40
X-Sequence-Number: 46686

On 4.4.2012 15:15, Scott Marlowe wrote:
> On Wed, Apr 4, 2012 at 3:42 AM, Cesar Martin <cmartinp@gmail.com> wrote:
>>
>> I have noticed that since I changed the setting  vm.zone_reclaim_mode = 0,
>> swap is totally full. Do you recommend me disable swap?
> 
> Yes

Careful about that - it depends on how you disable it.

Setting 'vm.swappiness = 0' is a good idea, don't remove the swap (I've
been bitten by the vm.overcommit=2 without a swap repeatedly).

T.