Re: Performance problems, bad estimates and plan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: allanvv(at)gmail(dot)com
Cc: pgsql-performance(at)postgreSQL(dot)org
Subject: Re: Performance problems, bad estimates and plan
Date: 2005-06-08 17:57:19
Message-ID: 9166.1118253439@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

[ Please cc your responses to the list; other people may be interested
in the same problem ]

Allan Wang <allanvv(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-06-08 18:06:53 Re: Performance problems, bad estimates and plan
Previous Message Tom Lane 2005-06-08 17:39:16 Re: Performance problems, bad estimates and plan