- 12.11.2011, 19:24
- This post has been edited 1 time(s), it was last edited by roopopper: 12.11.2011 19:50.
Originally posted by VorpalF2FThanks
In short, "vacuum analyse" checks your database integrity, and sucks out any dirt.
A thorough -- too thorough -- explanation is here:
http://wiki.postgresql.org/wiki/Introduction_to_VACUUM,_ANALYZE,_EXPLAIN,_and_COUNT
I don't do it often, but the other day, I regular on whom I have several hundred hands showed up at a table with only a few.
Following the vacuum analyse, all was sweetness and light.