From owner-freebsd-performance@FreeBSD.ORG  Wed Mar 14 12:44:24 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 9FB7716A402
	for <freebsd-performance@freebsd.org>;
	Wed, 14 Mar 2007 12:44:24 +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 62CED13C44C
	for <freebsd-performance@freebsd.org>;
	Wed, 14 Mar 2007 12:44:24 +0000 (UTC)
	(envelope-from freebsd@edwinm.ik.nu)
Received: from localhost (localhost [127.0.0.1])
	by mag.ik.nu (Postfix) with ESMTP id 523BEA1031;
	Wed, 14 Mar 2007 13:30:31 +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 VYeNS8IB6EGS; Wed, 14 Mar 2007 13:30:31 +0100 (CET)
Received: from [10.56.210.123] (ineo-y1a.hightechcampus.nl [194.171.252.108])
	by mag.ik.nu (Postfix) with ESMTP id 333A3A1030;
	Wed, 14 Mar 2007 13:30:31 +0100 (CET)
Message-ID: <45F7EAE6.4090300@edwinm.ik.nu>
Date: Wed, 14 Mar 2007 13:30:30 +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>
In-Reply-To: <200703141049.l2EAnPjc028880@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 12:44:24 -0000

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

Kind regards,
Edwin Mons