Re: [HACKERS] Potential vacuum bug? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Potential vacuum bug?
Date
Msg-id 4393.947604673@sss.pgh.pa.us
Whole thread Raw
In response to RE: [HACKERS] Potential vacuum bug?  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Responses RE: [HACKERS] Potential vacuum bug?
List pgsql-hackers
"Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
> I'm for your change.
> However I could hardly find the case that would cause a trouble.
> It may occur in the following rare cases though I'm not sure.

> HEAP_MOVED_OFF and (neither HEAP_XMIN_COMMITTED nor
> HEAP_XMIN_INVALID) and the tuple was recently delete/updated.

I'm not sure if HEAP_MOVED_OFF is really dangerous, but I am sure
that HEAP_MOVED_IN is dangerous --- vc_rpfheap will error out if
it hits a tuple marked that way.  So, if a VACUUM fails partway
through vc_rpfheap (I guess this would have to happen after the
internal commit), it'd be possible that later VACUUMs wouldn't
work anymore.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Don Baccus
Date:
Subject: Re: [HACKERS] Simmultanous Connections (fwd)
Next
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] Re: [SQL] createdb -D xxxx not working