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]
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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