From owner-freebsd-performance@FreeBSD.ORG Wed Mar 14 16:27:31 2007 Return-Path: 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 D37DF16A401 for ; Wed, 14 Mar 2007 16:27:31 +0000 (UTC) (envelope-from kris@obsecurity.org) Received: from elvis.mu.org (elvis.mu.org [192.203.228.196]) by mx1.freebsd.org (Postfix) with ESMTP id B725913C44B for ; Wed, 14 Mar 2007 16:27:31 +0000 (UTC) (envelope-from kris@obsecurity.org) Received: from obsecurity.dyndns.org (elvis.mu.org [192.203.228.196]) by elvis.mu.org (Postfix) with ESMTP id 93B871A4D80; Wed, 14 Mar 2007 09:27:31 -0700 (PDT) Received: by obsecurity.dyndns.org (Postfix, from userid 1000) id E659F515F1; Wed, 14 Mar 2007 12:27:30 -0400 (EDT) Date: Wed, 14 Mar 2007 12:27:30 -0400 From: Kris Kennaway To: Mike Tancsa Message-ID: <20070314162730.GB47727@xor.obsecurity.org> 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> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="xHFwDpU9dbj6ez1V" Content-Disposition: inline In-Reply-To: <200703141049.l2EAnPjc028880@lava.sentex.ca> User-Agent: Mutt/1.4.2.2i Cc: freebsd-performance@freebsd.org, Kris Kennaway Subject: Re: postgresql benchmarking (was: Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64) X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 14 Mar 2007 16:27:31 -0000 --xHFwDpU9dbj6ez1V Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Mar 14, 2007 at 06:47:23AM -0400, Mike Tancsa wrote: > At 03:16 AM 3/14/2007, Kris Kennaway wrote: >=20 >=20 > >On the pgsql side, disable the update_process_titles option (or > >whatever it is called), because this has a 33% performance overhead >=20 > Hi, > Is this a version specific config option or compile ? I cant=20 > find anything like that in the .conf or man pages It's a compile time option, but also can be disabled in the .conf file. At least on 8.1. Kris --xHFwDpU9dbj6ez1V Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (FreeBSD) iD8DBQFF+CJyWry0BWjoQKURAgkhAJsHWQ07g0NMp0kSXt1PFzBroxCWJwCg9Xr8 ec4KAQ7CoNR2ERdAHoAJ/Kg= =APwK -----END PGP SIGNATURE----- --xHFwDpU9dbj6ez1V--