Re: Really out of memory?

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Really out of memory?
Date: 2009-06-02 22:13:40
Message-ID: Pine.LNX.4.64.0906021505121.25644@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Louis Lam 2009-06-02 22:18:32 Re: catalog view use to find DATABASE, LANGUAGE, TABLESPACE, SCHEMA, SEQUENCE privileges granted to user or role
Previous Message Tom Lane 2009-06-02 21:48:05 Re: How can I manually alter the statistics for a column?