Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 12E502E00E9 for ; Wed, 26 Dec 2007 19:35:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 95378-10 for ; Wed, 26 Dec 2007 19:35:43 -0400 (AST) Received: from westnet.com (westnet.com [216.187.52.2]) by postgresql.org (Postfix) with ESMTP id E570C2E00E5 for ; Wed, 26 Dec 2007 19:35:43 -0400 (AST) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id lBQNZYhT019576; Wed, 26 Dec 2007 18:35:34 -0500 (EST) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id lBQNZX5c019572; Wed, 26 Dec 2007 18:35:33 -0500 (EST) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Wed, 26 Dec 2007 18:35:33 -0500 (EST) From: Greg Smith X-X-Sender: gsmith@westnet.com To: Guillaume Smet cc: pgsql-performance , Stefan Kaltenbrunner , =?ISO-8859-1?Q?Devrim_G=DCND=DCZ?= Subject: Re: More shared buffers causes lower performances In-Reply-To: <1d4e0c10712261453s4b171452g8aa30a1124f8fff1@mail.gmail.com> Message-ID: References: <1d4e0c10712251606q6f9503deye3da4b68c51bf5e@mail.gmail.com> <1198668065.4221.288.camel@ebony.site> <1d4e0c10712260741w1f141fd6x2f482143d526ad48@mail.gmail.com> <1d4e0c10712261352j2fbcd25ek1270331468d824b4@mail.gmail.com> <1d4e0c10712261453s4b171452g8aa30a1124f8fff1@mail.gmail.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/395 X-Sequence-Number: 28211 On Wed, 26 Dec 2007, Guillaume Smet wrote: > beta RPMs are by default compiled with --enable-debug and > --enable-cassert which doesn't help them to fly fast... Got that right. Last time I was going crazy after running pgbench with those options and not having realized what I changed, I was getting a 50% slowdown on results that way compared to without the debugging stuff. Didn't realize it scaled with shared_buffers though. > Really sorry for the noise Nothing to be sorry for, I know I wasn't aware the beta RPMs were compiled that way. Probably need to put a disclaimer about that fact *somewhere*. It's unfortunate for you, but I know I'm glad you run into it rather than someone who wouldn't have followed through to figure out the cause. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD