Received: from localhost (unknown [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id A15482E2B3B
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 27 Dec 2007 10:53:39 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 46588-06 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 27 Dec 2007 10:53:35 -0400 (AST)
Received: from oxford.xeocode.com (76-10-150-5.dsl.teksavvy.com [76.10.150.5])
	by postgresql.org (Postfix) with ESMTP id 805632E28AD
	for <pgsql-performance@postgresql.org>;
	Thu, 27 Dec 2007 10:53:35 -0400 (AST)
Received: from localhost ([127.0.0.1] helo=oxford.xeocode.com)
	by oxford.xeocode.com with esmtp (Exim 4.67)
	(envelope-from <stark@enterprisedb.com>)
	id 1J7u5J-0002OY-Vb; Thu, 27 Dec 2007 14:51:46 +0000
To: "Alvaro Herrera" <alvherre@commandprompt.com>
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>,  "Greg Smith" <gsmith@gregsmith.com>,
	"Guillaume Smet" <guillaume.smet@gmail.com>,
	"pgsql-performance" <pgsql-performance@postgresql.org>,
	"Stefan Kaltenbrunner" <stefan@kaltenbrunner.cc>,
	Devrim =?iso-8859-1?Q?G=DCND=DCZ?= <devrim@commandprompt.com>
Subject: Re: More shared buffers causes lower performances
In-Reply-To: <20071227132002.GC5709@alvh.no-ip.org> (Alvaro Herrera's message
	of "Thu\, 27 Dec 2007 10\:20\:03 -0300")
User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux)
X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX.performance" 3801)
References: <1d4e0c10712251606q6f9503deye3da4b68c51bf5e@mail.gmail.com>
	<1198668065.4221.288.camel@ebony.site>
	<1d4e0c10712260741w1f141fd6x2f482143d526ad48@mail.gmail.com>
	<Pine.GSO.4.64.0712261316580.11546@westnet.com>
	<1d4e0c10712261352j2fbcd25ek1270331468d824b4@mail.gmail.com>
	<1d4e0c10712261453s4b171452g8aa30a1124f8fff1@mail.gmail.com>
	<Pine.GSO.4.64.0712261816520.16448@westnet.com>
	<29359.1198735829@sss.pgh.pa.us>
	<20071227132002.GC5709@alvh.no-ip.org>
From: Gregory Stark <stark@enterprisedb.com>
Organization: EnterpriseDB
Date: Thu, 27 Dec 2007 14:51:40 +0000
Message-ID: <87fxxow5qb.fsf@oxford.xeocode.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200712/408
X-Sequence-Number: 28224

"Alvaro Herrera" <alvherre@commandprompt.com> writes:

> Tom Lane escribi=F3:
>
>> Currently the docs say that --enable-cassert
>>=20
>>          Enables <firstterm>assertion</> checks in the server, which tes=
t for
>>          many <quote>cannot happen</> conditions.  This is invaluable for
>>          code development purposes, but the tests slow things down a lit=
tle.
>>=20
>> Maybe we ought to put that more strongly --- s/a little/significantly/,
>> perhaps?
>
> I don't think it will make any difference, because people don't read
> configure documentation.  They read configure --help.

Fwiw I think you're all getting a bit caught up in this one context. While =
the
slowdown is significant when you take out the stopwatch, under normal
interactive use you're not going to notice your queries being especially sl=
ow.

--=20
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's On-Demand Production Tuning