From: | peter(at)vfemail(dot)net |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Vacuuming |
Date: | 2010-02-13 00:32:58 |
Message-ID: | 20100213161136.C876A6325BA@mail.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
There's a script running on my server hosting a PostgreSQL database that does some type of vacuuming routine every Friday at 5:00 p.m. Specifically, the script executes this command:
psql -d database_name -c "vacuum full verbose"
and e-mails the verbose output to me. Today's report today contains about 900,000 characters.
I don't event know where to begin reading that report, interpreting what it's telling me, determining what's important, or ascertaining what's routing and unimportant.
Can anybody give me any guidance or point me to a document that I should read to understand what the PostgreSQL vacuum does and why this is an important function and how to decipher the verbose output?
From | Date | Subject | |
---|---|---|---|
Next Message | APseudoUtopia | 2010-02-13 16:42:37 | Re: Vacuuming |
Previous Message | Brad Nicholson | 2010-02-12 19:28:50 | Re: db size and VACUUM ANALYZE |