X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EF2904758F1 for ; Wed, 16 Apr 2003 04:45:41 -0400 (EDT) Received: from smtp.web.de (smtp01.web.de [217.72.192.180]) by postgresql.org (Postfix) with ESMTP id 89CD8475458 for ; Wed, 16 Apr 2003 04:45:10 -0400 (EDT) Received: from p50818648.dip0.t-ipconnect.de ([80.129.134.72] helo=web.de) by smtp.web.de with asmtp (TLSv1:RC4-MD5:128) (WEB.DE(Exim) 4.97 #53) id 195iXQ-0002uG-00; Wed, 16 Apr 2003 10:45:04 +0200 Message-ID: <3E9D1820.6000100@web.de> Date: Wed, 16 Apr 2003 10:45:20 +0200 From: Andreas Pflug User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane , pgsql-performance@postgresql.org Subject: Re: Do Views offer any performance advantage? References: <001f01c30366$93427720$f3b0313e@LAIKA> <8832.1050427583@sss.pgh.pa.us> <3E9C63A8.4040801@web.de> <11035.1050449826@sss.pgh.pa.us> In-Reply-To: <11035.1050449826@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-34.4 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,RCVD_IN_NJABL, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_MOZILLA_UA 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/141 X-Sequence-Number: 1647 Tom Lane wrote: >This is not the view's fault though --- the same would have happened >if you'd written explicitly > > FROM A JOIN B JOIN (D JOIN E) > That's right, I just wanted to warn about accessive use of joins with views. I noticed this in an application, where quite big views where joined for convenience, and the result wasn't satisfying. > >7.4 will be less rigid about this (with or without a view ...) > Good! Regards, Andreas