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