Date: Wed, 14 Mar 2007 14:14:20 +0100 From: Edwin Mons <freebsd@edwinm.ik.nu> To: Mike Tancsa <mike@sentex.net> Cc: freebsd-performance@freebsd.org Subject: Re: postgresql benchmarking Message-ID: <45F7F52C.6010402@edwinm.ik.nu> In-Reply-To: <200703141302.l2ED2URR029383@lava.sentex.ca> References: <20070313154729.1ec6abb7@DELOREAN.manuelmartini.it> <20070313194206.GA5957@crodrigues.org> <20070313195756.GA11679@xor.obsecurity.org> <20070313211908.59de6504@DELOREAN.manuelmartini.it> <20070313214559.GB13079@xor.obsecurity.org> <330A1347-2309-417E-83B5-5B2CE005B9C8@solfertje.student.utwente.nl> <20070314005546.GA15742@xor.obsecurity.org> <45849703_-_@srv.sem.ipt.ru> <20070314071609.GA19728@xor.obsecurity.org> <200703141049.l2EAnPjc028880@lava.sentex.ca> <45F7EAE6.4090300@edwinm.ik.nu> <200703141302.l2ED2URR029383@lava.sentex.ca>
next in thread | previous in thread | raw e-mail | index | archive | help
Mike Tancsa wrote: > At 08:30 AM 3/14/2007, Edwin Mons wrote: >> Mike Tancsa wrote: >> > At 03:16 AM 3/14/2007, Kris Kennaway wrote: >> > >> > >> >> On the pgsql side, disable the update_process_titles option (or >> >> whatever it is called), because this has a 33% performance overhead >> > >> > Hi, >> > Is this a version specific config option or compile ? I cant >> > find anything like that in the .conf or man pages >> >> Put >> >> update_process_title = off >> >> in your postgresql.conf > > This is what I get with version 8 > > /usr/local/etc/rc.d/010.pgsql.sh start > FATAL: unrecognized configuration parameter "update_process_title" Judging by the name of your rc-script, you have an old version of PostgreSQL (read: pre-8.2). As far as I know, this option was introduced with PostgreSQL 8.2. Kind regards, Edwin Mons
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?45F7F52C.6010402>