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 EBD1952B49 for ; Thu, 28 Jul 2005 14:02:44 -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 04843-04 for ; Thu, 28 Jul 2005 17:02:39 +0000 (GMT) Received: from mail.travelamericas.com (unknown [206.130.134.147]) by svr1.postgresql.org (Postfix) with SMTP id 9BDDC52B5D for ; Thu, 28 Jul 2005 14:02:37 -0300 (ADT) Received: (qmail 6500 invoked from network); 28 Jul 2005 16:55:55 -0000 Received: from unknown (HELO ?10.0.0.253?) (10.0.0.253) by verkiel.travelamericas.com with SMTP; 28 Jul 2005 16:55:55 -0000 Message-ID: <42E90E19.3030702@travelamericas.com> Date: Thu, 28 Jul 2005 09:55:53 -0700 From: Chris Travers User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Gnanavel S Cc: pgsql-performance@postgresql.org Subject: Re: Left joining against two empty tables makes a query References: <42E86A03.1070803@travelamericas.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.037 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200507/441 X-Sequence-Number: 13682 Gnanavel S wrote: > > > vacuum & reindex the department and project table as the planner > expects there are 1060 rows but actually returning nothing. I guess I should have mentioned that I have been vacuuming and reindexing at least once a week, and I did so just before running this test. Normally I do: vacuum analyze; reindex database ....; Secondly, the project table has *never* had anything in it. So where are these numbers coming from? Best Wishes, Chris Travers Metatron Technology Consulting