The only way that I'm aware of for disabling this is at compile time ...
after running configure, you want to modify:
src/include/pg_config.h
and undef HAVE_SETPROCTITLE ...
I'm CC'ng -hackers about this though, since I think you are the first to
point to setproctitle() as being a serious performance bottleneck ...
On Sun, 11 Jun 2006, Kris Kennaway wrote:
> Why does postgresql change its process title so frequently and how can
> this be disabled? Profiling suggests it's a fairly serious
> performance bottleneck.
>
> Kris
>
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org MSN . scrappy@hub.org
Yahoo . yscrappy Skype: hub.org ICQ . 7615664
