and...@anarazel.de (Andres Freund) writes: > On 2014-06-10 11:20:28 -0400, Tom Lane wrote: >> Maybe I'm mistaken, but I thought once the fork_process code has reset our >> process's setting to zero it's not possible to lower it again (without >> privileges we'd not have).
> No, doesn't look that way. It's possible to reset it to the value set at > process start. So unless we introduce double forks for every backend > start it can be reset by ordinary processes. That's kind of annoying --- I wonder why they went to the trouble of doing that? But anyway, it's probably not worth the cost of double-forking to prevent it. I still say though that this is not a reason to make it as easy as change-a-GUC to break the intended behavior. Robert's idea of having the start script set an environment variable to control the OOM adjustment reset seems like it would satisfy my concern. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers