VACUUM FULL - Mailing list pgsql-novice

From Marcin Krol
Subject VACUUM FULL
Date
Msg-id 4911A403.6040302@gmail.com
Whole thread Raw
Responses Re: VACUUM FULL  ("Serge Fonville" <serge.fonville@gmail.com>)
List 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

pgsql-novice by date:

Previous
From: Marcin Krol
Date:
Subject: calculating table sizes + total in one query
Next
From: "Serge Fonville"
Date:
Subject: Re: VACUUM FULL