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

Re: Autovaccum and Full vacuum

From: Shoaib Mir <shoaibmir(at)gmail(dot)com>
To: Tony Day <tonyd(at)panztel(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Autovaccum and Full vacuum
Date: 2010-05-05 05:01:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Wed, May 5, 2010 at 2:46 PM, Tony Day <tonyd(at)panztel(dot)com> wrote:

> Hi Shoaib
> Thanks for the response.
> Sorry - I forgot to mention that I am using PostgreSQL 8.3.9 on Ubuntu
> 9.04.
> And just to be clear - I am not suggesting that there is a bug in
> Postgresql :-)
> I am just trying to clarify what it does and doesn't do.
You can find on docs autovacuum at

It uses VACUUM and not VACUUM FULL, there shouldn't be a need of VACUUM FULL
if you have autovacuum enabled with proper thresholds. There can be an odd
case where you might have to make auto-vacuum a little more aggressive for a
specific table.

Shoaib Mir

In response to


pgsql-novice by date

Next:From: Machiel RichardsDate: 2010-05-05 05:28:04
Subject: Autovacuum working / not working ?
Previous:From: Tony DayDate: 2010-05-05 04:46:31
Subject: Re: Autovaccum and Full vacuum

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