On Thu, Dec 02, 2004 at 05:07:17PM +0100, Dmitry Karasik wrote:
> While I agree that generally this is true, look how stupid this 
> behavior looks in this particular case: A developer creates a table
> and index, knowing that the table will be large and will be intensively 
> used. An admin runs 'VACUUM ANALYZE' when table is occasionally empty, 
> and next, say, 1 day, until another 'VACUUM ANALYZE' starts, the index 
> is simply not used! Sure you don't suppose to run 'VACUUM ANALYZE' every 
> 5 minutes as a solution, right?

No, you run autovacuum, which automatically re-analyzes at approximately the
right time.

/* Steinar */
Homepage: http://www.sesse.net/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to