On Tue, 2 Oct 2007 21:45:37 -0400 "Radhika S" <radhika.sambamurti@xxxxxxxxx> 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@xxxxxxxxx> | 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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
