>> indexes. I don't know whether autovacuum will also analyze tables >> for you automagically, but it would be a good idea to analyze the table > > It does.
So, I have checked my log and I see an autovacuum running once every minute on our various databases being hosted on the server - once every minute! >From what I can see, autovacuum is hitting the db's in question about once every five minutes. Does this imply an ANALYZE is being done automatically that would meet the requirements we are talking about here? Is there any benefit ot explicitly performing an ANALYZE? (Or does this go hand-in-and with turning off autovacuum...?) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
