Re: reprise on Linux overcommit handling

From: Ang Chin Han <angch(at)bytecraft(dot)com(dot)my>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: reprise on Linux overcommit handling
Date: 2003-07-23 03:11:33
Message-ID: 3F1DFCE5.5080800@bytecraft.com.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andrew Dunstan wrote:

> Rather than give bad advice, it might be better to advise users (1) to run
> Pg on machines that are likely to be stable and not run into OOM situations,
> and (2) to check with their vendors about proper overcommit handling.

Would it be possible (or trivial?) to write a small C program to test
for memory overcommit behaviour? Might be useful to put in contrib, and
mention it in the Admin docs. There are just too many Linux variants and
settings to be sure of what exactly the memory overcommit policy is for
a particular kernel and distribution.

Linux 2.6 will apparently behave better. I guess they have learnt the
lesson. :)

http://kniggit.net/wwol26.html (Under "Other Improvements").

--
Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386
GNU/Linux
10:30am up 209 days, 1:35, 5 users, load average: 5.08, 5.08, 5.08

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 2003-07-23 04:05:10 Re: tsearch2 for 7.3.X
Previous Message Bruce Momjian 2003-07-23 03:01:11 Re: reprise on Linux overcommit handling