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 45AB152814 for ; Wed, 8 Jun 2005 14:57:23 -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 00476-09 for ; Wed, 8 Jun 2005 17:57:21 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id D261B5283B for ; Wed, 8 Jun 2005 14:57:20 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j58HvJ2h009167; Wed, 8 Jun 2005 13:57:19 -0400 (EDT) To: allanvv@gmail.com Cc: pgsql-performance@postgreSQL.org Subject: Re: Performance problems, bad estimates and plan In-reply-to: <1118252779.4579.1.camel@localhost> References: <1118243044.3454.3.camel@localhost> <4362.1118250155@sss.pgh.pa.us> <1118250631.3454.6.camel@localhost> <9065.1118252356@sss.pgh.pa.us> <1118252779.4579.1.camel@localhost> Comments: In-reply-to Allan Wang message dated "Wed, 08 Jun 2005 13:46:19 -0400" Date: Wed, 08 Jun 2005 13:57:19 -0400 Message-ID: <9166.1118253439@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/181 X-Sequence-Number: 12818 [ Please cc your responses to the list; other people may be interested in the same problem ] Allan Wang writes: > On Wed, 2005-06-08 at 13:39 -0400, Tom Lane wrote: >> Are there any NULLs in c.playerid? > Here is the contents of cities: I'm sorry, what I should've said is "are there any NULLs in c.playerid in the output of the first LEFT JOIN?" In practice that means "does the selected row of tiles actually join to cities?" regards, tom lane