Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id DFBB62E0035 for ; Tue, 15 Apr 2008 06:25:47 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 71561-06 for ; Tue, 15 Apr 2008 06:25:35 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by developer.postgresql.org (Postfix) with ESMTP id A2ECA2E002E for ; Tue, 15 Apr 2008 06:25:40 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id m3F9PaFP091631 for ; Tue, 15 Apr 2008 06:25:36 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id m3F9B01S086307 for pgsql-performance@postgresql.org; Tue, 15 Apr 2008 06:11:00 -0300 (ADT) (envelope-from news) From: Gaetano Mendola X-Newsgroups: pgsql.performance Subject: Re: shared_buffers performance Date: Tue, 15 Apr 2008 11:11:31 +0200 Organization: Hub.Org Networking Services Lines: 13 Message-ID: <48047143.5000107@gmail.com> References: <48032021.90704@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: Greg Smith User-Agent: Thunderbird 2.0.0.12 (X11/20080227) In-Reply-To: To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/189 X-Sequence-Number: 29682 Greg Smith wrote: > On Mon, 14 Apr 2008, Gaetano Mendola wrote: > >> I'm using postgres 8.2.3 on Red Hat compiled with GCC 3.4.6. > > 8.2.3 has a performance bug that impacts how accurate pgbench results > are; you really should be using a later version. Thank you, I will give it a shot and performe some tests to see if they change a lot, in case I will repeat the entire benchmarks. Regards Gaetano Mendola