X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7ADF7D1B1E4 for ; Fri, 14 May 2004 15:26:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 77474-07 for ; Fri, 14 May 2004 15:25:56 -0300 (ADT) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id C7A69D1B26A for ; Fri, 14 May 2004 15:25:52 -0300 (ADT) Received: from [134.22.68.74] (dyn-68-74.tor.dsl.tht.net [134.22.68.74]) by tht.net (Postfix) with ESMTP id 44DC276AD7; Fri, 14 May 2004 14:25:56 -0400 (EDT) Subject: Re: TPCH 100GB - need some help From: Rod Taylor To: Eduardo Almeida Cc: Postgresql Performance In-Reply-To: <20040514180037.8730.qmail@web60608.mail.yahoo.com> References: <20040514180037.8730.qmail@web60608.mail.yahoo.com> Content-Type: text/plain Message-Id: <1084570822.672.43.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Fri, 14 May 2004 17:40:23 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=2.8 tagged_above=0.0 required=5.0 tests=DATE_IN_FUTURE_03_06 X-Spam-Level: ** X-Archive-Number: 200405/141 X-Sequence-Number: 6972 On Fri, 2004-05-14 at 14:00, Eduardo Almeida wrote: > Hi folks, > > I need some help in a TPCH 100GB benchmark. Performance with 7.5 is much improved over 7.4 for TPCH due to efforts of Tom Lane and OSDL. Give it a try with a recent snapshot of PostgreSQL. Otherwise, disable nested loops for that query. set enable_nestloop = off;