Re: H800 + md1200 Performance problem - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: H800 + md1200 Performance problem
Date
Msg-id CAOR=d=0SQ7K4PGMqjpNj6URg+Bn8A4Duo2bkX2-QXvp7xy4mjg@mail.gmail.com
Whole thread Raw
In response to Re: H800 + md1200 Performance problem  (Tomas Vondra <tv@fuzzy.cz>)
Responses Re: H800 + md1200 Performance problem  (Claudio Freire <klaussfreire@gmail.com>)
Re: H800 + md1200 Performance problem  (Tomas Vondra <tv@fuzzy.cz>)
List pgsql-performance
On Wed, Apr 4, 2012 at 7:20 AM, Tomas Vondra <tv@fuzzy.cz> wrote:
> 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).

I've had far more problems with swap on and swappiness set to 0 than
with swap off.  But this has always been on large memory machines with
64 to 256G memory.  Even with fairly late model linux kernels (i.e.
10.04 LTS through 11.04) I've watched the kswapd start up swapping
hard on a machine with zero memory pressure and no need for swap.
Took about 2 weeks of hard running before kswapd decided to act
pathological.

Seen it with swap on, with swappiness to 0, and overcommit to either 0
or 2 on big machines.  Once we just took the swap partitions away it
the machines ran fine.

pgsql-performance by date:

Previous
From: superman0920
Date:
Subject: about multiprocessingmassdata
Next
From: Claudio Freire
Date:
Subject: Re: H800 + md1200 Performance problem