Re: pg/linux How much swap relative to physical memory is needed? - Mailing list pgsql-general

From Cédric Villemain
Subject Re: pg/linux How much swap relative to physical memory is needed?
Date
Msg-id AANLkTikSEg9ZVxN2TKjRo3C7zRyLgiaDWYmNTRg0dLPu@mail.gmail.com
Whole thread Raw
In response to Re: pg/linux How much swap relative to physical memory is needed?  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-general
2010/6/10 Alan Hodgson <ahodgson@simkin.ca>:
> On Thursday, June 10, 2010, Kelly Burkhart <kelly.burkhart@gmail.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@postgresql.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

pgsql-general by date:

Previous
From: Mike Christensen
Date:
Subject: Re: Best way to store case-insensitive data?
Next
From: Steve Crawford
Date:
Subject: Re: database response slows while pg_dump is running (8.4.2)