Skip site navigation (1) Skip section navigation (2)

Re: vacuum full question.

From: "M(dot) Bastin" <marcbastin(at)mindspring(dot)com>
To: Michael Guerin <guerin(at)rentec(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: vacuum full question.
Date: 2004-04-21 17:34:56
Message-ID: a06020400bcac60d82186@[192.168.0.101] (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-novice
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(at)postgresql(dot)org)


In response to

Responses

pgsql-novice by date

Next:From: Michael GuerinDate: 2004-04-21 17:50:13
Subject: Re: vacuum full question.
Previous:From: Michael GuerinDate: 2004-04-21 17:23:57
Subject: vacuum full question.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group