Re: More shared buffers causes lower performances - Mailing list pgsql-performance

From Greg Smith
Subject Re: More shared buffers causes lower performances
Date
Msg-id Pine.GSO.4.64.0712271022280.3927@westnet.com
Whole thread Raw
In response to Re: More shared buffers causes lower performances  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: More shared buffers causes lower performances  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: More shared buffers causes lower performances  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Mark Mielke
Date:
Subject: Re: With 4 disks should I go for RAID 5 or RAID 10
Next
From: Tom Lane
Date:
Subject: Re: More shared buffers causes lower performances