Postgresql performance profiling

[Marc G. Fournier]

On Sun, 11 Jun 2006, Kris Kennaway wrote:

> * The postgres processes seem to change their proctitle hundreds or 
> thousands of times per second.  This is currently done via a 
> Giant-locked sysctl (kern.proc.args) so there is enormous contention for 
> Giant.  Even when this is fixed (thanks to a patch from csjp@), each of 
> them requires a syscall and syscalls ain't free.  This is not a clever 
> thing to be doing from a performance standpoint.

to disable for testing, after you run configure, manually edit 
src/include/pg_config.h and undef HAVE_SETPROCTITLE ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy at hub.org                              MSN . scrappy at hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664