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: | x2jbf54be871005042201g3865b946jb2df7180a12f249c@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
http://www.postgresql.org/docs/8.3/static/routine-vacuuming.html#AUTOVACUUM
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
http://shoaibmir.wordpress.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Machiel Richards | 2010-05-05 05:28:04 | Autovacuum working / not working ? |
Previous Message | Tony Day | 2010-05-05 04:46:31 | Re: Autovaccum and Full vacuum |