Vacuuming Questions

From: John Gardner <john(dot)gardner(at)tagish(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Vacuuming Questions
Date: 2008-04-23 15:27:33
Message-ID: 480F5565.5040303@tagish.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-04-23 15:31:36 Re: Backup setup
Previous Message Merlin Moncure 2008-04-23 15:27:14 Re: Need to update all my 60 million rows at once without transactional integrity