Re: Query optimizer 8.0.1 (and 8.0) - Mailing list pgsql-hackers

> pgsql@mohawksoft.com writes:
>>    ->  Index Scan using rt1_zipr, rt1_zipl on rt1  (cost=0.00..121893.93
>> rows=30835 width=302)
>>          Index Cond: ((zipr = 2186) OR (zipl = 2186))
>
>>  zipl      |        925 |
>>  zipr      |        899 |
>
> Those n_distinct values for zipl and zipr seem aberrant --- too low
> compared to the estimated rowcount you're showing.  What are the
> true figures?  Also, how about some EXPLAIN ANALYZEs and not just
> EXPLAINs?
>
>                                   ^
tiger=# select count(distinct(zipr)), count(distinct(zipl)) from rt1 ;count | count
-------+-------35133 | 35393
(1 row)