Re: Performance problems, bad estimates and plan - Mailing list pgsql-performance

From Tom Lane
Subject Re: Performance problems, bad estimates and plan
Date
Msg-id 9166.1118253439@sss.pgh.pa.us
Whole thread Raw
In response to Performance problems, bad estimates and plan  (Allan Wang <allanvv@gmail.com>)
List pgsql-performance
[ Please cc your responses to the list; other people may be interested
  in the same problem ]

Allan Wang <allanvv@gmail.com> 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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance problems, bad estimates and plan
Next
From: Tom Lane
Date:
Subject: Re: Performance problems, bad estimates and plan