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

Re: H800 + md1200 Performance problem

From: Tomas Vondra <tv(at)fuzzy(dot)cz>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: H800 + md1200 Performance problem
Date: 2012-04-04 13:20:46
Message-ID: 4F7C4AAE.4060608@fuzzy.cz (view raw or flat)
Thread:
Lists: pgsql-performance
On 4.4.2012 15:15, Scott Marlowe wrote:
> On Wed, Apr 4, 2012 at 3:42 AM, Cesar Martin <cmartinp(at)gmail(dot)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.

In response to

Responses

pgsql-performance by date

Next:From: Kim HansenDate: 2012-04-04 13:47:17
Subject: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster
Previous:From: Scott MarloweDate: 2012-04-04 13:15:31
Subject: Re: H800 + md1200 Performance problem

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