postgresql benchmarking

Edwin Mons freebsd at edwinm.ik.nu
Wed Mar 14 13:14:27 UTC 2007


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



More information about the freebsd-performance mailing list