Re: oom_killer - Mailing list pgsql-performance

From Claudio Freire
Subject Re: oom_killer
Date
Msg-id BANLkTimwYuoq+gKqcjJtgqjEv6kf5zwbZA@mail.gmail.com
Whole thread Raw
In response to Re: oom_killer  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
List pgsql-performance
On Fri, Apr 22, 2011 at 6:45 PM, Cédric Villemain
<cedric.villemain.debian@gmail.com> wrote:
> Are you sure it is a PAE kernel ? You look limited to 4GB.

If my memory/knowledge serves me right, PAE doesn't remove that limit.
PAE allows more processes, and they can use more memory together, but
one process alone has to live within an addressable range, and that is
still 4GB, mandated by the 32-bit addressable space when operating in
linear addressing mode.

But linux kernels usually reserve 1GB for kernel stuff (buffers and
that kind of stuff), so the addressable portion for processes is 3GB.

Take away 2.5GB of shared buffers, and you only leave 0.5G for general
data and code.

Really, lowering shared_buffers will probably be a solution. Moving to
64 bits would be a better one.

pgsql-performance by date:

Previous
From: Marinos Yannikos
Date:
Subject: Re: postgresql random io test with 2 SSD Kingston V+100 500GB in (software) Raid1
Next
From: Greg Smith
Date:
Subject: Re: OT (slightly) testing for data loss on an SSD drive due to power failure