Re: help with getting index scan

"Thomas T. Thai" <tom@minnesota.com> writes:
> On Mon, 25 Feb 2002, Tom Lane wrote:
>> How many distinct cid values do you have?  Also, which PG version is
>> this?

>   5139

Hmm, seems like that ought to be selective enough.  What does pg_stats
show for phone_cat_address?  (And phone_cat, for that matter.)

If you set enable_seqscan to off, do you get a plan you like better?
If so, what is it?

            regards, tom lane