Re: help with getting index scan

On 25 Feb 2002, Doug McNaught wrote:

> "Thomas T. Thai" <tom@minnesota.com> writes:
>
> > i can't seem to get index scan to work on table phone_cat_address. here
> > are my schemas:
>
> Standard question: have you run VACUUM ANALYZE?

yes :) before each test.

> Also, the estimate of rows returned from the phone_cat_address scan is
> pretty large--how large is the table itself?  Sequential scan is
> actually faster if you're going to end up returning most of the rows
> in the table...

yellowpages=# select count(*) from phone_cat_address;
 count
--------
 336702
(1 row)

type typical results should be a tiny fraction of that number.

---
Thomas T. Thai | Minnesota.com | tom@minnesota.com | 612.220.6220
Visit http://www.minnesota.com/