Skip site navigation (1) Skip section navigation (2)

Re: about the performance of autovacuum and vacuumdb?

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: ivan(dot)hou <ivan(dot)hou(at)msa(dot)hinet(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: about the performance of autovacuum and vacuumdb?
Date: 2007-12-20 22:13:28
Message-ID: dcc563d10712201413obadbba8xf02e143fa4da959f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Dec 20, 2007 12:50 AM, ivan.hou <ivan(dot)hou(at)msa(dot)hinet(dot)net> wrote:
>
> i try to compare two methods of garbage-collect.(Postgresql Ver:8.1.3)
>
> 1. enable autovacuum without using vacuumdb -f mydb in crontab.
> 2. using crontab to vacuumdb in every 10 min (autovacuum disable)
>
> the method 2 got more free space than method 1.
>
> the disk size of database still  increased in method 1.
> so, what's the advantage of autovacuum?

That really depends.  Did the db size increase at first under method
1, then reach a steady state, or did it just keep bloating.  It might
well be that vacuuming every 10 minutes cost you more in terms of
performance than would using autovacuum, and the trade off was
slightly more disk space used.  Or it could be the db was bloating.
If the db was bloating, as Alvaro mentioned, you likely don't have
aggressive enough settings for autovacuum.

Also, update your pg install to the latest 8.1.x version, 8.1.3 has
quite a few nasty bugs in it.

In response to

pgsql-admin by date

Next:From: Tom DaviesDate: 2007-12-22 02:02:50
Subject: on-line backup questions
Previous:From: Alvaro HerreraDate: 2007-12-20 18:31:57
Subject: Re: about the performance of autovacuum and vacuumdb?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group