"Thomas T. Thai" <tom@minnesota.com> writes:
> i can't seem to get index scan to work on table phone_cat_address. here
> are my schemas:
Standard question: have you run VACUUM ANALYZE?
Also, the estimate of rows returned from the phone_cat_address scan is
pretty large--how large is the table itself? Sequential scan is
actually faster if you're going to end up returning most of the rows
in the table...
-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863