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 5AA74D1B176 for ; Sat, 15 May 2004 13:01:41 -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 78770-02 for ; Sat, 15 May 2004 13:01:11 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id E70D2D1B1C2 for ; Sat, 15 May 2004 13:00:37 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i4FG0Xnp007285; Sat, 15 May 2004 12:00:33 -0400 (EDT) To: Eduardo Almeida Cc: pgsql-performance@postgresql.org Subject: Re: TPCH 100GB - need some help In-reply-to: <20040514180037.8730.qmail@web60608.mail.yahoo.com> References: <20040514180037.8730.qmail@web60608.mail.yahoo.com> Comments: In-reply-to Eduardo Almeida message dated "Fri, 14 May 2004 11:00:37 -0700" Date: Sat, 15 May 2004 12:00:33 -0400 Message-ID: <7284.1084636833@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/144 X-Sequence-Number: 6975 Eduardo Almeida writes: > I need some help in a TPCH 100GB benchmark. > Here I put the query #19, the explain and the "top" > for it. IIRC, this is one of the cases that inspired the work that's been done on the query optimizer for 7.5. I don't think you will be able to get 7.4 to generate a good plan for it (at least not without changing the query, which is against the TPC rules). How do you feel about running CVS tip? BTW, are you aware that OSDL has already done a good deal of work with running TPC benchmarks for Postgres (and some other OS databases)? regards, tom lane