Re: help with getting index scan - Mailing list pgsql-general

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.