From: Michael Stone <mstone+postgres@mathom.us>
To: pgsql-performance@postgresql.org
Subject: Re: Postgres server crash
Date: Sun, 19 Nov 2006 13:41:07 -0500
Message-ID: <20061119184105.GC2366@mathom.us> (raw)
In-Reply-To: <Pine.LNX.4.33.0611181713170.19262-100000@denzel.in>
References: <19583.1163700841@sss.pgh.pa.us>
<Pine.LNX.4.33.0611181713170.19262-100000@denzel.in>
On Sat, Nov 18, 2006 at 05:28:46PM -0800, Richard Troy wrote:
>On linux you can use the sysctl utility to muck with vm.overcommit_memory;
>You can disable the "feature."
Be aware that there's are "reasons" the "feature" exists before you
"cast" "aspersions" and "quote marks" all over the place, and the
"reasons" are "things" like "shared memory" and "copy on write"
memory, which are "generally" condsidered "good things".
At one point someone complained about the ability to configure, e.g.,
IRIX to allow memory overcommit. I worked on some large IRIX
installations where full memory accounting would have required on the
order of 100s of gigabytes of swap, due to large shared memory
allocations. If the swap had been configured rather than allowing
overcommit, sure it might have reduced the chance of an application
allocating memory that it couldn't use. In practice, if you're 100s of
gigs into swap the system isn't going to be useable anyway.
>itself any memory. Frankly, if it takes a complete kernel rewrite to fix
>the problem that the damned operating system can't manage its own needs,
>then the kernel needs to be rewritten! </soapbox>
>
>These kernel hackers could learn something from VAX/VMS.
Like how to make a slower system? You can configure a VM to operate
the way they did 25 years ago, but in general people have preferred to
get better performance (*much* better performance) instead. It could be
that they're all idiots, or it could be that in practice the problem
isn't as bad as you make it out to be. (Maybe other people are just
better at configuring their memory usage?)
Mike Stone
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mstone+postgres@mathom.us
Subject: Re: Postgres server crash
In-Reply-To: <20061119184105.GC2366@mathom.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox