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/