pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Gregory Stark <stark@enterprisedb.com>
To: Greg Smith <gsmith@gregsmith.com>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Guillaume Smet <guillaume.smet@gmail.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Cc: Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
Cc: Devrim GÜNDÜZ <devrim@commandprompt.com>
Subject: Re: More shared buffers causes lower performances
Date: Thu, 27 Dec 2007 16:42:44 +0000
Message-ID: <87bq8cw0l7.fsf@oxford.xeocode.com> (raw)
In-Reply-To: <Pine.GSO.4.64.0712271022280.3927@westnet.com>
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>

"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!



view thread (26+ messages)  latest in thread

Message-ID: <87bq8cw0l7.fsf@oxford.xeocode.com>
Permalink:  ../87bq8cw0l7.fsf@oxford.xeocode.com/
Also on:    postgresql.org/message-id/87bq8cw0l7.fsf@oxford.xeocode.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: stark@enterprisedb.com, gsmith@gregsmith.com, alvherre@commandprompt.com, tgl@sss.pgh.pa.us, guillaume.smet@gmail.com, stefan@kaltenbrunner.cc, devrim@commandprompt.com
  Subject: Re: More shared buffers causes lower performances
  In-Reply-To: <87bq8cw0l7.fsf@oxford.xeocode.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox