Re: Sequential scan being used despite indexes

James Russell <internationalhobo@gmail.com>

From: James Russell <internationalhobo@gmail.com>
To: Michael Fuhr <mike@fuhr.org>
Cc: "Joshua D. Drake" <jd@commandprompt.com>, pgsql-performance@postgresql.org
Date: 2006-02-01T04:33:08Z
Lists: pgsql-performance
[Sorry, my last reply didn't go to the list]

Reading about this issue further in the FAQ, it seems that I should ensure
that Postgres has adequate and accurate information about the tables in
question by regularly running VACUUM ANALYZE, something I don't do
currently.

I disabled SeqScan as per the FAQ, and it indeed was a lot slower so
Postgres was making the right choice in this case.

Many thanks,

James