X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4E761568D9 for ; Tue, 15 Mar 2005 17:17:37 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 09396-06 for ; Tue, 15 Mar 2005 17:17:34 +0000 (GMT) Received: from boutiquenumerique.com (boutiquenumerique.com [82.67.9.10]) by svr1.postgresql.org (Postfix) with ESMTP id 137D0568D6 for ; Tue, 15 Mar 2005 17:17:33 +0000 (GMT) Received: (qmail 2433 invoked from network); 15 Mar 2005 18:17:37 +0100 Received: from unknown (HELO localhost) (boutiquenumerique-lists@192.168.0.4) by boutiquenumerique.com with SMTP; 15 Mar 2005 18:17:37 +0100 To: "Tom Lane" , pgsql-hackers@postgresql.org Cc: =?iso-8859-15?B?TWlyb3NsYXYgpnVsYw==?= , pgsql-performance@postgresql.org Subject: Re: [PERFORM] Avoiding tuple construction/deconstruction during joining References: <42345D24.8070104@startnet.cz> <14577.1110821062@sss.pgh.pa.us> Message-ID: Date: Tue, 15 Mar 2005 18:17:31 +0100 From: PFC Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?= Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit In-Reply-To: <14577.1110821062@sss.pgh.pa.us> User-Agent: Opera M2/7.54 (Linux, build 955) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/722 X-Sequence-Number: 65524 I have asked him for the data and played with his queries, and obtained massive speedups with the following queries : http://boutiquenumerique.com/pf/miroslav/query.sql http://boutiquenumerique.com/pf/miroslav/query2.sql http://boutiquenumerique.com/pf/miroslav/materialize.sql Note that my optimized version of the Big Joins is not much faster that the materialized view without index (hash joins are damn fast in postgres) but of course using an index...