From owner-freebsd-performance@FreeBSD.ORG  Wed Mar 14 13:14:27 2007
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
X-Original-To: freebsd-performance@freebsd.org
Delivered-To: freebsd-performance@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id 55EEC16A407
	for <freebsd-performance@freebsd.org>;
	Wed, 14 Mar 2007 13:14:27 +0000 (UTC)
	(envelope-from freebsd@edwinm.ik.nu)
Received: from mag.ik.nu (mag.ik.nu [81.17.40.97])
	by mx1.freebsd.org (Postfix) with ESMTP id 1776C13C448
	for <freebsd-performance@freebsd.org>;
	Wed, 14 Mar 2007 13:14:26 +0000 (UTC)
	(envelope-from freebsd@edwinm.ik.nu)
Received: from localhost (localhost [127.0.0.1])
	by mag.ik.nu (Postfix) with ESMTP id 13C2CA100F;
	Wed, 14 Mar 2007 14:14:26 +0100 (CET)
X-Virus-Scanned: amavisd-new at ik.nu
Received: from mag.ik.nu ([127.0.0.1])
	by localhost (mag.ik.nu [127.0.0.1]) (amavisd-new, port 10024)
	with SMTP id IEuuOKCJ3bRA; Wed, 14 Mar 2007 14:14:20 +0100 (CET)
Received: from [10.56.210.123] (ineo-y1a.hightechcampus.nl [194.171.252.108])
	by mag.ik.nu (Postfix) with ESMTP id BDF77A1021;
	Wed, 14 Mar 2007 14:14:20 +0100 (CET)
Message-ID: <45F7F52C.6010402@edwinm.ik.nu>
Date: Wed, 14 Mar 2007 14:14:20 +0100
From: Edwin Mons <freebsd@edwinm.ik.nu>
User-Agent: Thunderbird 1.5.0.10 (X11/20070306)
MIME-Version: 1.0
To: Mike Tancsa <mike@sentex.net>
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>
In-Reply-To: <200703141302.l2ED2URR029383@lava.sentex.ca>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Cc: freebsd-performance@freebsd.org
Subject: Re: postgresql benchmarking
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Performance/tuning <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 14 Mar 2007 13:14:27 -0000

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