RE: Why vacuum? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject RE: Why vacuum?
Date
Msg-id NEBBIOAJBMEENKACLNPCOEKLCCAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: Why vacuum?  (bpalmer <bpalmer@crimelabs.net>)
Responses RE: Why vacuum?  (Tim Allen <tim@proximity.com.au>)
List pgsql-hackers
> But why?  I don't know of other databases that need to be 'vacuum'ed.  Do
> all others just do it internaly on a regular basis?
>
> What am I missing here?

Plenty of other databases need to be 'vacuumed'.  For instance, if you have
an ms access database with 5 MB of data in it, and then delete all the data,
leaving only the forms, etc - you will be left with a 5MB mdb file still!

If you then run 'Compact Database' (which is another word for 'vacuum'), the
mdb file will be reduced down to 500k...

Chris



pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: Why vacuum?
Next
From: Tim Allen
Date:
Subject: RE: Why vacuum?