2011/4/22 Tory M Blue <tmblue@gmail.com>:
> On Fri, Apr 22, 2011 at 9:45 AM, Cédric Villemain
> <cedric.villemain.debian@gmail.com> wrote:
>
>>> CommitLimit: 4128760 kB
>>> Committed_AS: 2380408 kB
>>
>> Are you sure it is a PAE kernel ? You look limited to 4GB.
>
> Figured that the Commitlimit is actually the size of swap, so on one
> server it's 4gb and the other it's 5gb.
>
> So still need to figure out with 32gig of ram and 4 to 5gig swap, what
> my overcommit ratio should be.
at least the default value of 50, probably more, up to you to adjust.
You should have something ok with 50, given that it used to work well
until now with 0 (so you'll have 21GB of commitable memory )
>
> Tory
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
--
Cédric Villemain 2ndQuadrant
http://2ndQuadrant.fr/ PostgreSQL : Expertise, Formation et Support