Re: vacuum full question.

Sure, however this is not a data consistency issue, it's a maintenance
routine.  If its shuffling around data to free up pages, it seems it
should be able to save some of this work.  For instance, SQL server has
a command to defrag an index: dbcc indexdefrag which I believe is
similar to vacuum, in that it reorganizes the data  check out:.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_30o9.asp


M. Bastin wrote:

> The general principle is that any transaction that is being canceled
> is fully lost and the database remains in the same state as before the
> transaction was started.
>
> I don't know the pgsql internals but I don't see why this shouldn't be
> the case for a VACUUM too.
>
> Marc
>
> At 1:23 PM -0400 4/21/04, Michael Guerin wrote:
>
>> What happens when a vacuum full is canceled?  Is any of the completed
>> work retained, or is everything lost?
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 2: you can get off all lists at once with the unregister command
>>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>