VACUUM FULL

From: Marcin Krol <mrkafk(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: VACUUM FULL
Date: 2008-11-05 13:47:47
Message-ID: 4911A403.6040302@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello everyone,

I've done VACUUM FULL on my db and noticed that it reclaimed
considerably more diskspace than regular VACUUM.

Should I use VACUUM FULL or not? Are there any downsides/risks to it
(other than that it locks the table while vacuuming)?

Conversely, are there any performance advantages of db after doing
VACUUM FULL?

The docs on VACUUM FULL do not say what it does exactly (in detail)..

Regards,
Marcin Krol

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Serge Fonville 2008-11-05 14:06:17 Re: VACUUM FULL
Previous Message Marcin Krol 2008-11-05 13:07:41 calculating table sizes + total in one query