X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AABCE54310 for ; Fri, 13 May 2005 02:57:02 -0300 (ADT) 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 72111-02 for ; Fri, 13 May 2005 05:56:52 +0000 (GMT) Received: from stark.xeocode.com (stark.xeocode.com [216.58.44.227]) by svr1.postgresql.org (Postfix) with ESMTP id BE7D0538B4 for ; Fri, 13 May 2005 02:56:51 -0300 (ADT) Received: from localhost ([127.0.0.1] helo=stark.xeocode.com) by stark.xeocode.com with smtp (Exim 3.36 #1 (Debian)) id 1DWTAC-000221-00; Fri, 13 May 2005 01:56:44 -0400 To: pgsql-performance@postgresql.org Subject: Re: Optimize complex join to use where condition before References: <4283D985.4080908@laliluna.de> <428414DE.8030904@laliluna.de> In-Reply-To: <428414DE.8030904@laliluna.de> From: Greg Stark Organization: The Emacs Conspiracy; member since 1992 Date: 13 May 2005 01:56:44 -0400 Message-ID: <8764xnoehv.fsf@stark.xeocode.com> Lines: 21 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/255 X-Sequence-Number: 12419 Sebastian Hennebrueder writes: > User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) > ... > > "Nested Loop (cost=1349.13..1435.29 rows=1 width=2541) (actual > time=1640.000..3687.000 rows=62 loops=1)" > " Join Filter: ("inner".fid = "outer".faufgaben_id)" > " -> Index Scan using idx_tauf_mit_mitid on taufgaben_mitarbeiter am > (cost=0.00..80.65 rows=35 width=4) (actual time=0.000..0.000 rows=765 > loops=1)" Is it really Mozilla Thunderbird that's causing this new craptastic mangling of plans in people's mails? I was assuming it was some new idea of how to mess up people's mail coming out of Exchange or Lotus or some other such "corporate messaging" software that only handled SMTP mail as an afterthought. This is, uh, disappointing. -- greg