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

From Tom Lane
Subject Re: help with getting index scan
Date
Msg-id 21306.1014653057@sss.pgh.pa.us
Whole thread Raw
In response to help with getting index scan  ("Thomas T. Thai" <tom@minnesota.com>)
Responses Re: help with getting index scan
List pgsql-general
"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

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Work Around For Oracle Feature
Next
From: "Thomas T. Thai"
Date:
Subject: Re: help with getting index scan