Y Sidhu escribió: > I am trying to follow a message thread. One guy says we should be running > vacuum analyze daily and the other says we should be running vacuum multiple > times a day. I have tried looking for what a vacuum analyze is to help me > understand but no luck.
VACUUM ANALYZE is like VACUUM, except that it also runs an ANALYZE afterwards. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match