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

help / color / mirror / Atom feed
From: Greg Smith <gsmith@gregsmith.com>
To: Gregory Stark <stark@enterprisedb.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 10:53:43 -0500 (EST)
Message-ID: <Pine.GSO.4.64.0712271022280.3927@westnet.com> (raw)
In-Reply-To: <87fxxow5qb.fsf@oxford.xeocode.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>

On Thu, 27 Dec 2007, Gregory Stark wrote:

> Fwiw I think you're all getting a bit caught up in this one context.

I lost a day once over this problem.  Guillaume lost at least that much. 
Sounds like Magnus and Dave got a good sized dose as well.  Seems like 
something worth warning people about to me.  The worst time people can run 
into a performance regression is when they're running a popular 
benchmarking tool.  I didn't think this was a big problem because I 
thought it was limited to developers who shot their own foot, but if there 
are packagers turning this on to improve beta feedback it deserves some 
wider mention.

As for the suggestion that people don't read the documentation, take a 
look at the above list of developers and tell me whether that group is 
aware of what's in the docs or not.  I had never seen anyone bring this up 
before I ran into it, and I dumped a strong warning into 
http://developer.postgresql.org/index.php/Working_with_CVS#Initial_setup 
so at least it was written down somewhere.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD



view thread (26+ messages)  latest in thread

Message-ID: <Pine.GSO.4.64.0712271022280.3927@westnet.com>
Permalink:  ../Pine.GSO.4.64.0712271022280.3927@westnet.com/
Also on:    postgresql.org/message-id/Pine.GSO.4.64.0712271022280.3927@westnet.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: gsmith@gregsmith.com, stark@enterprisedb.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: <Pine.GSO.4.64.0712271022280.3927@westnet.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