On Mon, 25 Feb 2002, Tom Lane wrote:
> "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?
yellowpages=# select count(distinct(cid)) from phone_cat_address;
count
-------
5139
(1 row)
this is 7.2. i'm just trying to find ways to narrow the search time down.
it's currently taking several seconds.