Re: Sequential scan being used despite indexes

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>

To: James Russell <internationalhobo@gmail.com>

Cc: Michael Fuhr <mike@fuhr.org>, "Joshua D. Drake" <jd@commandprompt.com>, pgsql-performance@postgresql.org

Date: 2006-02-01T04:43:57Z

Lists: pgsql-performance

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

Well then you'll get rubbish performance always in PostgreSQL...

I strongly suggest you run autovacuum if you don't really understand 
PostgreSQL vacuuming/analyzing.

Chris