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?
        regards, tom lane