One Question out of curiosity .. How did u cancel the vacuum full ?.
1. killed the process id .. eg using kill -9
2. canceled the vacuum full from command prompt eg using "ctrl C".
3. or did an immediate shutdown .
On 1/18/06, Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Wed, 2006-01-18 at 12:1
On Wed, 2006-01-18 at 12:17, Anjan Dave wrote:
> Hi,
>
> I just had to cancel one VACUUM FULL (of a 4.3m row table) that someone ran
> in business hours. It was after an hour or so that I realized, and it was
> blocking queries, running out of connections, so I cancelled it. Are there
> any ba
Hi, I just had to cancel one VACUUM FULL (of a 4.3m row table) that someone ran in business hours. It was after an hour or so that I realized, and it was blocking queries, running out of connections, so I cancelled it. Are there any bad side effects of cancelling an ongoing full vacuum of a t
