Re: fsm and vacuum - Mailing list pgadmin-support

From Michael Shapiro
Subject Re: fsm and vacuum
Date
Msg-id AANLkTimVn-MkByzvYG8Jb6a3-f6ZbChKp65DiK-A9erq@mail.gmail.com
Whole thread Raw
In response to Re: fsm and vacuum  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: fsm and vacuum
List pgadmin-support
The document http://wiki.postgresql.org/wiki/VACUUM_FULL says:

VACUUM FULL, unlike VACUUM, tuples data that has not been deleted, moving it into spaces earlier in the file that have been freed. Once it's created a free space at the end of the file, it truncates the file so that the OS knows that space is free and may be reused for other things. Moving in-use data around this way has some major downsides and side-effects, especially the way VACUUM FULL does it. There are better ways to free space if you need to and better ways to optimize tables (see below) so you should essentially never use VACUUM FULL.


PgAdmin does not give the user a comparable warning when it goes to execute a VACCUM FULL. Given the potential problems with the FULL option, would it make sense for PgAdmin to issue a warning to this effect?

On Fri, Dec 3, 2010 at 2:54 AM, Guillaume Lelarge <guillaume@lelarge.info> wrote:

> We're experiencing problems using vacuum full. 
This could be of interest:

 http://wiki.postgresql.org/wiki/VACUUM_FULL


pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: fsm and vacuum
Next
From: Guillaume Lelarge
Date:
Subject: Re: fsm and vacuum