Re: Seq scan on join, not on subselect? analyze this

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bryce Nesbitt <bryce2(at)obviously(dot)com>
Cc: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Seq scan on join, not on subselect? analyze this
Date: 2008-11-02 18:38:21
Message-ID: 4529.1225651101@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Bryce Nesbitt <bryce2(at)obviously(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bryce Nesbitt 2008-11-02 20:14:43 Re: Seq scan on join, not on subselect? analyze this
Previous Message Bryce Nesbitt 2008-11-02 18:04:01 Seq scan on join, not on subselect? analyze this