Обсуждение: update_process_title=off and logger, wal, ... processes

Поиск
Список
Период
Сортировка

update_process_title=off and logger, wal, ... processes

От
Rod Taylor
Дата:
With the update_process_title parameter set to off some PostgreSQL
processes still change their ps title to a different name than the
default. I appreciate this setting came about for performance reasons
which the logger, wal writer, autovacuum, and stats collector would
not have but I actually require the default and patched
init_ps_display() to skip changing the name.

It just surprised me that the titles still changed a single time.

I (stupidly?) installed PostgreSQL into a hostile environment which
didn't like this and decided to kill the processes as a result.
Unfortunately, I cannot change the environment.


Re: update_process_title=off and logger, wal, ... processes

От
Tom Lane
Дата:
Rod Taylor <rod.taylor@gmail.com> writes:
> With the update_process_title parameter set to off some PostgreSQL
> processes still change their ps title to a different name than the
> default.

s/some/all/ ... they all do that.  It's as designed.  The parameter is
intended to suppress the overhead of changing the title for every
command, not to make it impossible to tell the child processes apart.

> I (stupidly?) installed PostgreSQL into a hostile environment which
> didn't like this and decided to kill the processes as a result.

That's one pretty d*mn hostile environment, all right.  Consider
finding a less brain-dead platform.
        regards, tom lane


Re: update_process_title=off and logger, wal, ... processes

От
Stephen Frost
Дата:
* Rod Taylor (rod.taylor@gmail.com) wrote:
> I (stupidly?) installed PostgreSQL into a hostile environment which
> didn't like this and decided to kill the processes as a result.
> Unfortunately, I cannot change the environment.

That's not hostile, that's broken.
Stephen