Re: heavy swapping, not sure why - Mailing list pgsql-general

From Merlin Moncure
Subject Re: heavy swapping, not sure why
Date
Msg-id CAHyXU0zmim+KTNmVi+bF0SONTuGR+eD17=gvFSziSEWqNuJb4g@mail.gmail.com
Whole thread Raw
In response to Re: heavy swapping, not sure why  (Alan Hodgson <ahodgson@simkin.ca>)
Responses Re: heavy swapping, not sure why
List pgsql-general
On Mon, Aug 29, 2011 at 3:46 PM, Alan Hodgson <ahodgson@simkin.ca> wrote:
> On August 29, 2011 01:36:07 PM Lonni J Friedman wrote:
>> I have several Linux-x68_64 based dedicated PostgreSQL servers where
>> I'm experiencing significant swap usage growth over time.
>
> It's the Linux kernel that does it, not PostgreSQL. Set vm.swappiness=0
> (usually in /etc/sysctl.conf) and put that into effect.

that won't help and, in almost all cases, is a bad idea.

merlin

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: heavy swapping, not sure why
Next
From: Merlin Moncure
Date:
Subject: Re: heavy swapping, not sure why