Vacuuming Questions
От | John Gardner |
---|---|
Тема | Vacuuming Questions |
Дата | |
Msg-id | 480F5565.5040303@tagish.co.uk обсуждение исходный текст |
Ответы |
Re: Vacuuming Questions
Re: Vacuuming Questions |
Список | pgsql-general |
We have two PostgreSQL servers (8.2) running in a cluster. We have autovacuum switched on on both servers and also we are running the following as a cron job; Server 1: 30 0,2,4,6,8,10,12,14,16,18,20,22 * * * /usr/bin/vacuumdb --all --analyze Server 2: 30 1,3,5,7,9,11,13,15,17,19,21,23 * * * /usr/bin/vacuumdb --all --analyze So, in other words we stagger the jobs one each server in the cluster. Now, we're not seeing any problems with performance and we're not seeing any bloat but I have a couple of questions which I hope some of you can help me out on. 1) Is using the autovacuum daemon and running vacuumdb from a cron job overkill? 2) The vendor of the clustering software suggests that I regularly run vacuum --all --analyze on a specific table. Surely, if I'm running vacuumdb --all --analyze isn't this just a wrapper for running the vacuum --all --analyze command anyway? I guess that I'm asking why would I want to run vacuum --all --analyze on a specific table, when I regularly run vacuumdb --all --analyze on all databases? Any help would be grateful. Thanks John
В списке pgsql-general по дате отправления: