Re: BUG #2225: Backend crash -- BIG table

From: Patrick Rotsaert <patrick(dot)rotsaert(at)arrowup(dot)be>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: BUG #2225: Backend crash -- BIG table
Date: 2006-02-03 17:10:03
Message-ID: 43E38E6B.3010204@arrowup.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


>0 means overcommit is enabled. You want to set it to something other
>than 0 to prevent overcommitting and the consequent suprising process
>deaths. Exactly what other values are accepted varies, but 0 isn't the
>one for you.
>
>
>
I do not understand how 0 could mean overcommit is enabled. I do not
know how it is in recent kernels, but the source code of the 2.4 kernel
I use is this:

int vm_enough_memory(long pages)
{
unsigned long free;

/* Sometimes we want to use more memory than we have. */
if (sysctl_overcommit_memory)
return 1;

// ...
}

seems pretty straightforward to me.
I also did a recursive grep through all of the kernel source and this is
the only place where this parameter is used.
I tried setting the parameter to 1, but it did not make any difference.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Patrick Rotsaert 2006-02-03 17:15:42 Re: BUG #2225: Backend crash -- BIG table
Previous Message Stephan Szabo 2006-02-03 16:43:54 Re: BUG #2225: Backend crash -- BIG table