Date: Sun, 11 Jun 2006 18:37:05 -0300 (ADT) From: "Marc G. Fournier" <scrappy@hub.org> To: Kris Kennaway <kris@obsecurity.org> Cc: scrappy@FreeBSD.org, performance@FreeBSD.org Subject: Re: Postgresql performance profiling Message-ID: <20060611183544.D1114@ganymede.hub.org> In-Reply-To: <20060611174527.GA31119@xor.obsecurity.org> References: <20060611174527.GA31119@xor.obsecurity.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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@hub.org MSN . scrappy@hub.org Yahoo . yscrappy Skype: hub.org ICQ . 7615664
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060611183544.D1114>