Postgresql performance profiling

Marc G. Fournier scrappy at
Sun Jun 11 21:37:04 UTC 2006

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 (
Email . scrappy at                              MSN . scrappy at
Yahoo . yscrappy               Skype:        ICQ . 7615664

More information about the freebsd-performance mailing list