Обсуждение: update_process_title=off and logger, wal, ... processes
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.
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
* 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