Re: Really out of memory? - Mailing list pgsql-general

From Ben Chobot
Subject Re: Really out of memory?
Date
Msg-id Pine.LNX.4.64.0906021505121.25644@localhost.localdomain
Whole thread Raw
In response to Re: Really out of memory?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
On Tue, 2 Jun 2009, Martijn van Oosterhout wrote:

> It's got nothing to do with how much swap is in use. It's preventing
> you from allocating memory that *hypothetically* might not be available
> if every byte of allocated memory were actually used.
>
> For example, on my desktop I have 1GB of RAM of which about 600MB is
> free, yet there is 1.4GB committed. With overcommit off my machine
> may not boot. As you can see, only 25% of committed memory is actually
> needed, because lots of pages are blank or shared. Ofcourse, all those
> copies of libc are realistically never not going to be shared so it's a
> good bet.
>
> But with overcommit off you can see that you might want to have double
> or triple the amount of swap to handle the hypothetical case.

No, sorry, I don't see why I would need more swap when I've disabled
memory overcommit. As I understand it, the kernel should be able to
allocate (swap + (physical * overcommit_ratio)), which in my case is just
swap+physical, and it seems to not want to do that.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How can I manually alter the statistics for a column?
Next
From: "Louis Lam"
Date:
Subject: Re: catalog view use to find DATABASE, LANGUAGE, TABLESPACE, SCHEMA, SEQUENCE privileges granted to user or role