Re: Sequential scan being used despite indexes - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: Sequential scan being used despite indexes
Date
Msg-id 43E03C8D.4050305@familyhealth.com.au
Whole thread Raw
In response to Re: Sequential scan being used despite indexes  (James Russell <internationalhobo@gmail.com>)
List 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


pgsql-performance by date:

Previous
From: James Russell
Date:
Subject: Re: Sequential scan being used despite indexes
Next
From: Michael Fuhr
Date:
Subject: Re: Sequential scan being used despite indexes