On Wed, Mar 06, 2002 at 09:57:48AM +0100, [EMAIL PROTECTED] wrote: > > Hi, > > What function does VACUUM play in 7.2 ? Since a normal VACUUM does not > reclaim space, is it run only to update statistics ? > Is VACUUM still very slow on very large tables (over 50GB) like in 7.1 ? > > Regards > Robert
In the 7.2 docs it explains what the new and improved vscuum does. It will go through a table and mark deleted tuples as free so the db can reuse allocked disk space. there is also a new option that will give you the old behavior. It is in the 7.2 admin guide chapter 8. marc > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
