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

From Doug McNaught
Subject Re: help with getting index scan
Date
Msg-id m3y9hhzjfs.fsf@varsoon.denali.to
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. here
> are my schemas:

Standard question: have you run VACUUM ANALYZE?

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...

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Work Around For Oracle Feature
Next
From: Devrim GUNDUZ
Date:
Subject: Re: install psql 7.1.3 - rh6.2 - libreadline.so.4