Re: PostgreSQL 8.0.6 crash - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PostgreSQL 8.0.6 crash
Date
Msg-id 1627.1139500418@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL 8.0.6 crash  ("Mark Woodward" <pgsql@mohawksoft.com>)
Responses Re: PostgreSQL 8.0.6 crash
Re: PostgreSQL 8.0.6 crash
List pgsql-hackers
"Mark Woodward" <pgsql@mohawksoft.com> writes:
> Still, I would say that is is extremly bad behavior for not having
> stats, wouldn't you think?

Think of it as a kernel bug.

>> Meanwhile, I'd strongly recommend turning off OOM kill.  That's got to
>> be the single worst design decision in the entire Linux kernel.

> How is this any different than the FreeBSD having a default 512M process
> size limit? On FreeBSD, the process would have been killed earlier.

No, the process would have been politely told it was out of memory, and
would have told you the same.  If the kernel's way of notifying a
process that it's out of memory is SIGKILL, there is not a damn thing
that we can do to operate robustly.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Mark Woodward"
Date:
Subject: Re: PostgreSQL 8.0.6 crash
Next
From: "Mark Woodward"
Date:
Subject: Re: PostgreSQL 8.0.6 crash