I'm doing VACUUM ANALYZE once a night. Before the tests I did VACUUM and then ANALYZE.
I'd suggest once an hour on any resonably active database...
Chris
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
