| From: | "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net> |
|---|---|
| To: | "Radhika S" <radhika(dot)sambamurti(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Difference between Vacuum and Vacuum full |
| Date: | 2007-10-03 02:02:01 |
| Message-ID: | 20071002220201.2722a499.darcy@druid.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, 2 Oct 2007 21:45:37 -0400
"Radhika S" <radhika(dot)sambamurti(at)gmail(dot)com> wrote:
> But this has bought me to the question of what exactly is the
> difference between vacuum and vacuum full. If both give back free
> space to the disk, then why have vacuum full.
Not quite. "VACUUM FULL" returns space to the system. "VACUUM" only
frees the space for use by the database. In most cases a simple VACUUM
is all you need since you are going to just be asking for the space
back anyway eventually as your database grows.
--
D'Arcy J.M. Cain <darcy(at)druid(dot)net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Radhika S | 2007-10-03 03:05:14 | Re: Difference between Vacuum and Vacuum full |
| Previous Message | Rodrigo De León | 2007-10-03 01:56:26 | Re: Difference between Vacuum and Vacuum full |