[Babase] Backups of the Postgres pg_autovacuum system table

Karl O. Pinc kop at meme.com
Sun Mar 29 22:38:23 EDT 2009


(Original message went to Ryan.)

Hi Ryan,

I just noticed that the upstream postgres backup
tools do not back up the pg_autovacuum system
table.  We should add that to the backup
script, someday.

On papio we're not using pg_autovacuum, which is used
to tune automatic vacuuming on a per table
basis.  Someday we might.

FYI

You're probably not using it anywhere else either.
(I think by default autovacuuming is off.
I think Hunter had a vacuum cron script
for other systems. We don't want one on papio.
You're probably better off using auto vacuuming
instead of a cron script.  Autovacumming was
introduced around pg 8.0 or thereabouts.
So older systems won't even have the table.)



Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list