From: Alvaro Herrera on
Magnus Hagander wrote:
> I realize this is a very platform-specific thing, but should we
> consider setting the value of /proc/<pid>/oom_adj when running on
> linux? See:

http://archives.postgresql.org/message-id/20080201223336.GC24780%40alvh.no-ip.org

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

From: Magnus Hagander on
On Mon, Jan 4, 2010 at 16:45, Alvaro Herrera <alvherre(a)commandprompt.com> wrote:
> Magnus Hagander wrote:
>> I realize this is a very platform-specific thing, but should we
>> consider setting the value of /proc/<pid>/oom_adj when running on
>> linux? See:
>
> http://archives.postgresql.org/message-id/20080201223336.GC24780%40alvh.no-ip.org

Grr. I had zero recollectoin of that :S

Can't find a useful consensus though?


--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

From: "Joshua D. Drake" on
On Mon, 4 Jan 2010 16:57:28 +0100, Magnus Hagander <magnus(a)hagander.net>
wrote:
> On Mon, Jan 4, 2010 at 16:45, Alvaro Herrera
<alvherre(a)commandprompt.com>
> wrote:
>> Magnus Hagander wrote:
>>> I realize this is a very platform-specific thing, but should we
>>> consider setting the value of /proc/<pid>/oom_adj when running on
>>> linux? See:
>>
>>
http://archives.postgresql.org/message-id/20080201223336.GC24780%40alvh.no-ip.org
>
> Grr. I had zero recollectoin of that :S
>
> Can't find a useful consensus though?

I don't think we should set a setting like that automatically. Perhaps a
warning on startup?

Joshua D. Drake

--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

From: Andrew Dunstan on


Magnus Hagander wrote:
> On Mon, Jan 4, 2010 at 16:45, Alvaro Herrera <alvherre(a)commandprompt.com> wrote:
>
>> Magnus Hagander wrote:
>>
>>> I realize this is a very platform-specific thing, but should we
>>> consider setting the value of /proc/<pid>/oom_adj when running on
>>> linux? See:
>>>
>> http://archives.postgresql.org/message-id/20080201223336.GC24780%40alvh.no-ip.org
>>
>
> Grr. I had zero recollectoin of that :S
>
> Can't find a useful consensus though?
>
>

It is probably worth trying to protect the postmaster in the init
script. Beyond that things probably start to get fairly difficult.

cheers

andrew

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

From: Magnus Hagander on
On Mon, Jan 4, 2010 at 17:07, Andrew Dunstan <andrew(a)dunslane.net> wrote:
>
>
> Magnus Hagander wrote:
>>
>> On Mon, Jan 4, 2010 at 16:45, Alvaro Herrera <alvherre(a)commandprompt.com>
>> wrote:
>>
>>>
>>> Magnus Hagander wrote:
>>>
>>>>
>>>> I realize this is a very platform-specific thing, but should we
>>>> consider setting the value of /proc/<pid>/oom_adj when running on
>>>> linux? See:
>>>>
>>>
>>>
>>> http://archives.postgresql.org/message-id/20080201223336.GC24780%40alvh.no-ip.org
>>>
>>
>> Grr. I had zero recollectoin of that :S
>>
>> Can't find a useful consensus though?
>>
>>
>
> It is probably worth trying to protect the postmaster in the init script.
> Beyond that things probably start to get fairly difficult.

Right. But AFAICS (though I haven't tested with -17), it will become
inherited to children, which is something we'd want to *undo*, no?


--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers