"Thomas T. Thai" <tom@minnesota.com> writes:
> i can't seem to get index scan to work on table phone_cat_address.
The planner seems to think that the cid column alone isn't very
selective, and thus indexscanning on it wouldn't be useful.
How many distinct cid values do you have? Also, which PG version is
this?
regards, tom lane