Received: from localhost (unknown [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 1FAF52E00F2
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 27 Dec 2007 13:01:46 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 54404-06-3
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 27 Dec 2007 13:01:40 -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 4C0172E02A4
	for <pgsql-performance@postgresql.org>;
	Thu, 27 Dec 2007 12:44:39 -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 1J7voo-0002S1-D9; Thu, 27 Dec 2007 16:42:50 +0000
To: "Greg Smith" <gsmith@gregsmith.com>
Cc: "Alvaro Herrera" <alvherre@commandprompt.com>,
	"Tom Lane" <tgl@sss.pgh.pa.us>,
	"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: <Pine.GSO.4.64.0712271022280.3927@westnet.com> (Greg Smith's
	message of "Thu\, 27 Dec 2007 10\:53\:43 -0500 \(EST\)")
User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux)
X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX" 55975)
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>
	<87fxxow5qb.fsf@oxford.xeocode.com>
	<Pine.GSO.4.64.0712271022280.3927@westnet.com>
From: Gregory Stark <stark@enterprisedb.com>
Organization: EnterpriseDB
Date: Thu, 27 Dec 2007 16:42:44 +0000
Message-ID: <87bq8cw0l7.fsf@oxford.xeocode.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200712/416
X-Sequence-Number: 28232

"Greg Smith" <gsmith@gregsmith.com> writes:

> The worst time people can run into a performance
> regression is when they're running a popular benchmarking tool.  

Hm, perhaps pg_bench should do a "show debug_assertions" and print a warning
if the answer isn't "off". We could encourage other benchmark software to do
something similar.

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's RemoteDBA services!