Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E5E529FA0DF for ; Fri, 2 Nov 2007 19:28:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 98744-03-3 for ; Fri, 2 Nov 2007 19:27:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 72E9D9FA14E for ; Fri, 2 Nov 2007 19:27:25 -0300 (ADT) Received: from alvh.no-ip.org (200-126-73-212.bk5-dsl.surnet.cl [200.126.73.212]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.7) with ESMTP id lA2MRO6Z006705; Fri, 2 Nov 2007 15:27:25 -0700 Received: by alvh.no-ip.org (Postfix, from userid 1000) id ACDA356000B; Fri, 2 Nov 2007 15:45:48 -0300 (CLST) Date: Fri, 2 Nov 2007 15:45:48 -0300 From: Alvaro Herrera To: Sami Dalouche Cc: pgsql-performance , Tom Lane Subject: Re: [Fwd: Re: Outer joins and Seq scans] Message-ID: <20071102184548.GA2460@alvh.no-ip.org> Mail-Followup-To: Sami Dalouche , pgsql-performance , Tom Lane References: <1193865739.23774.2.camel@samlaptop> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1193865739.23774.2.camel@samlaptop> User-Agent: Mutt/1.5.16 (2007-06-11) X-Virus-Scanned: ClamAV 0.91.1/4659/Thu Nov 1 09:24:40 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Fri, 02 Nov 2007 15:27:26 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/37 X-Sequence-Number: 27452 Sami Dalouche wrote: > -- For some reason, my message doesn't seem to go through the mailing > list, so I am trying without any attachment FWIW, you can post EXPLAIN ANALYZE results on the web here: http://www.explain-analyze.info/ It's a pretty cool utility by Michael Glaesemann that should makes our lives a bit better (at least along a certain axis). -- Alvaro Herrera http://www.PlanetPostgreSQL.org/ "The problem with the future is that it keeps turning into the present" (Hobbes)