Postgres Pro
Downloads
Home   >   mailing lists

Re: Seq scan on join, not on subselect? analyze this - Mailing list pgsql-sql

From Tom Lane
Subject Re: Seq scan on join, not on subselect? analyze this
Date
Msg-id 4529.1225651101@sss.pgh.pa.us
Whole thread Raw
In response to Seq scan on join, not on subselect? analyze this  (Bryce Nesbitt <bryce2@obviously.com>)
Responses Re: Seq scan on join, not on subselect? analyze this
List pgsql-sql
Tree view 
Bryce Nesbitt <bryce2@obviously.com> writes:
> I'm a bit confused why the query planner is not restricting my join, and
> not using the index.  Two explain analyze statements follow.

Why are the rowcount estimates so far off?  Maybe you need to increase
the statistics target for this table.
        regards, tom lane

pgsql-sql by date:

Previous
From: Bryce Nesbitt
Date:
Subject: Seq scan on join, not on subselect? analyze this
Next
From: Bryce Nesbitt
Date:
Subject: Re: Seq scan on join, not on subselect? analyze this