X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id DDD299FA22C for ; Fri, 19 May 2006 17:01:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 57868-02 for ; Fri, 19 May 2006 17:01:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from alvh.no-ip.org (201-220-122-179.bk10-dsl.surnet.cl [201.220.122.179]) by postgresql.org (Postfix) with ESMTP id AD04C9FA278 for ; Fri, 19 May 2006 17:00:59 -0300 (ADT) Received: by alvh.no-ip.org (Postfix, from userid 1000) id 93808C3742C; Fri, 19 May 2006 16:00:57 -0400 (CLT) Date: Fri, 19 May 2006 16:00:57 -0400 From: Alvaro Herrera To: Warren Little Cc: "Tomeh, Husam" , pgsql-admin@postgresql.org Subject: Re: query optimization - mysql vs postgresql Message-ID: <20060519200057.GD4444@surnet.cl> Mail-Followup-To: Warren Little , "Tomeh, Husam" , pgsql-admin@postgresql.org References: <1147970616.29462.20.camel@rearden1.reardeninc.local> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1147970616.29462.20.camel@rearden1.reardeninc.local> User-Agent: Mutt/1.5.11+cvs20060403 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/280 X-Sequence-Number: 21812 Warren Little wrote: > Sorry, > here are the attachments. > Not sure about the statistics question, I have done a vacuum analyze on > every table in the database. The problem is that the planner is unable to appropiately order OUTER JOINs in released versions. In 8.2 it can do some reordering, so it would probably come up with a better plan. Without jumping to 8.2, however, the best you could do is reorder the query yourself manually. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support