VACUUM
| От | Jodi Kanter |
|---|---|
| Тема | VACUUM |
| Дата | |
| Msg-id | 016e01c28c1d$f9db6340$de138f80@virginia.edu обсуждение исходный текст |
| Ответы |
Re: VACUUM
|
| Список | pgsql-admin |
I am trying to set up my cron job to run the appropriate vacuums on our database. I understand from reading the documentation that regular vacuums, vacuum full, and vacuum analyze are all important. Can someone assist in telling me what is the most efficient order? I would assume that analyze should be done once the inaccessible rows are released within the table and then to the OS?
We currently have a small amount of data in our database so my plan was to do all vacuums on the entire database.
Also, I read that reindexing was important. Does this need to be done as frequently as the vacuums? Is it only done on a per table basis? or can you reindex the entire database?
Thanks
Jodi
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu
В списке pgsql-admin по дате отправления: