X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C83FF475F1B for ; Tue, 1 Apr 2003 07:23:30 -0500 (EST) Received: from spirit.aldeiadigital.com.br (iplus-fac-213-137.xdsl-fixo.ctbcnetsuper.com.br [200.225.213.137]) by postgresql.org (Postfix) with ESMTP id AE3B8475AF8 for ; Tue, 1 Apr 2003 07:23:28 -0500 (EST) Received: from aldeiadigital.com.br (localhost.localdomain [127.0.0.1]) by spirit.aldeiadigital.com.br (8.11.6/8.11.6) with SMTP id h31CNfa13948 for ; Tue, 1 Apr 2003 09:23:42 -0300 Received: from 200.170.156.137 (proxying for 126.0.0.10) (SquirrelMail authenticated user alepaes) by webmail.ad2.com.br with HTTP; Tue, 1 Apr 2003 09:23:42 -0300 (BRT) Message-ID: <39940.200.170.156.137.1049199822.squirrel@webmail.ad2.com.br> Date: Tue, 1 Apr 2003 09:23:42 -0300 (BRT) Subject: Re: 30-70 seconds query... From: "alexandre :: aldeia digital" To: In-Reply-To: <25846.1049151512@sss.pgh.pa.us> References: <10846.200.225.202.15.1049145207.squirrel@webmail.ad2.com.br> <25610.1049149040@sss.pgh.pa.us> <25846.1049151512@sss.pgh.pa.us> X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal X-Mailer: SquirrelMail (version 1.2.7) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Virus-Scanned: by amavisd-milter (http://amavis.org/) Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-25.1 required=5.0 tests=BAYES_10,IN_REP_TO,MISSING_MIMEOLE,MISSING_OUTLOOK_NAME, QUOTED_EMAIL_TEXT,REFERENCES,REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/1 X-Sequence-Number: 1507 Tom, I will try the current snapshot and I will report in the list. Thanks to Tomasz Myrta too for the help. Alexandre > I said: >> PG 7.4 will be better prepared to handle this sort of query, but I >> don't think it will realize that the T1/T2 left join could be reduced >> to a plain join given these conditions > > I take that back --- actually, the algorithm used in CVS tip *does* > deduce that all these left joins can be plain joins. > > Don't suppose you'd like to experiment with a current snapshot to see > how well it does for you? > > regards, tom lane