Vacuuming
От | peter@vfemail.net |
---|---|
Тема | Vacuuming |
Дата | |
Msg-id | 20100213161136.C876A6325BA@mail.postgresql.org обсуждение исходный текст |
Ответы |
Re: Vacuuming
|
Список | pgsql-novice |
There's a script running on my server hosting a PostgreSQL database that does some type of vacuuming routine every Fridayat 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, orascertaining 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 doesand why this is an important function and how to decipher the verbose output?
В списке pgsql-novice по дате отправления: