From: | "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: is this a bug or do I not understand the query planner? |
Date: | 2005-11-03 23:55:03 |
Message-ID: | dke805$18rl$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
"Rob Prowel" <tempest766(at)yahoo(dot)com> wrote
> two almost identical queries: one searches for
>
> read in ('N','n')
>
> and the other searches for
>
> read in ('Y','y').
>
> the (explain) SQL statement says that one uses the
> index on the (read) field and the other does a
> sequential table scan. Why!!!????
With big chance, it is not a bug. As your explain indicates, Yy query is
estimated only return 1 row while Nn query is estimated to return 2018135
rows. So for the latter, compared to your table size(I guess), an seqscan is
more suitable.
Try "explain analyze" to see if the query optimizer gets a right guess. If
not, run "vacuum full analyze", then check again. If still not, you may want
to post the results here.
Regards,
Qingqing
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2005-11-03 23:59:27 | Re: is this a bug or do I not understand the query planner? |
Previous Message | Rob Prowel | 2005-11-03 23:36:48 | is this a bug or do I not understand the query planner? |