Re: Out of Memory - 8.2.4 - Mailing list pgsql-general

From Tom Lane
Subject Re: Out of Memory - 8.2.4
Date
Msg-id 6118.1188612846@sss.pgh.pa.us
Whole thread Raw
In response to Re: Out of Memory - 8.2.4  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Also, note that the worst thing that can happen is that the wrong
> process gets a SIGUSR1 signal, and the launcher misses an opportunity
> for starting another worker and rebalancing the vacuum cost parameters.

Hmmm ... okay, but I note that part of that assumption is that every
postgres-owned process either ignores SIGUSR1 or handles it in a fashion
such that an extra signal won't cause any Bad Things.  This is not
obvious, especially considering that the Unix default action for SIGUSR1
is abnormal process termination.  I'm starting to think that we need a
README somewhere collecting all the system's assumptions about signal
handling.

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Out of Memory - 8.2.4
Next
From: "Marco Bizzarri"
Date:
Subject: Re: computing and updating the size of a table with large objects