Re: pg/linux How much swap relative to physical memory is needed?

From: Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
To: Alan Hodgson <ahodgson(at)simkin(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg/linux How much swap relative to physical memory is needed?
Date: 2010-06-10 22:20:29
Message-ID: AANLkTikSEg9ZVxN2TKjRo3C7zRyLgiaDWYmNTRg0dLPu@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/6/10 Alan Hodgson <ahodgson(at)simkin(dot)ca>:
> On Thursday, June 10, 2010, Kelly Burkhart <kelly(dot)burkhart(at)gmail(dot)com> wrote:
>> Should I be concerned?
>>
>> Thanks,
>
> The default Linux kernel settings will tend to swap stuff out to make more
> memory available for filesystem cache. You can lower the value set in
> /proc/sys/vm/swappiness to decrease this tendency. I don't think it's
> hurting anything, though; it just has pages it thinks can be usefully
> swapped out.

you can read
* /usr/src/linux/Documentation/vm/overcommit-account
to get more info.

But depending of your OOMKiller mode, the size of the swap is used to
determine the total commit memory.
So if your swap is too small with huge RAM, and mode 2 for OOM you
might not used all of your available memory.

>
> --
> "No animals were harmed in the recording of this episode. We tried but that
> damn monkey was just too fast."
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
Cédric Villemain 2ndQuadrant
http://2ndQuadrant.fr/ PostgreSQL : Expertise, Formation et Support

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2010-06-10 22:41:53 Re: database response slows while pg_dump is running (8.4.2)
Previous Message Mike Christensen 2010-06-10 21:59:50 Re: Best way to store case-insensitive data?