Re: Hung Vacuum in 8.3 - Mailing list pgsql-bugs

From Mark Kirkwood
Subject Re: Hung Vacuum in 8.3
Date
Msg-id 4D64282F.2030400@catalyst.net.nz
Whole thread Raw
In response to Re: Hung Vacuum in 8.3  (Greg Stark <gsstark@mit.edu>)
Responses Re: Hung Vacuum in 8.3  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List pgsql-bugs
On 23/02/11 00:26, Greg Stark wrote:
>
> It's also possible there's a bug of course. If someone was using that
> buffer and somehow failed to notify the vacuum that they were done it
> would wait for a very long time (forever?). However if vacuum
> eventually continued when the query was canceled then it seems likely
> it was working as intended.
>

Greg, thanks for clarifying this.

Unfortunately this time around I canceled the vacuum and then the query.
However *next* time I'll get rid of the query 1st and see what happens.

Cheers

Mark

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: BUG #5898: Nested "in" clauses hide bad column names
Next
From: Mark Kirkwood
Date:
Subject: Re: Hung Vacuum in 8.3