Re: https://www.postgresql.org/docs/current/kernel-resources.html

PG Doc comments form <noreply(at)postgresql(dot)org> writes:
> I believe, that the export of PG_OOM_ADJUST_FILE should not point to the
> file that the postmaster uses, but should be for example:

> export PG_OOM_ADJUST_FILE=/proc/self/oom_score_adj_child

> As if the example is blindly followed, then postmaster version of the file
> would be updated and become a candidate to be killed.

I don't think so. In the first place, you misunderstand what
this variable does: it is only consulted by postmaster child
processes not the postmaster itself. In the second place,
"/proc/self/oom_score_adj_child" isn't universal (it does not
exist on any of the Red-Hat-based distros I checked).

If it were universal and had the semantics that I guess it means from
the name, we could perhaps implement this feature differently and more
simply. But it's not, and I don't see a lot of value in supporting
two different implementations.

regards, tom lane