Re: VACUUM in 7.2

On Wed, Mar 06, 2002 at 09:57:48AM +0100, Robert.Farrugia@go.com.mt 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 majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly