Re: Unexpected VACUUM FULL failure - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: Unexpected VACUUM FULL failure
Date
Msg-id 874pj8rrhe.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Unexpected VACUUM FULL failure  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Unexpected VACUUM FULL failure  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-hackers
"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> "Simon Riggs" <simon@2ndquadrant.com> writes:
>
>> ISTM that if we call HeapTupleSatisfiesVacuum() with an additional
>> boolean parameter, force, we can tell VF to always set the hint bits in
>> every case, not just HEAP_MOVED_IN and HEAP_MOVED_OUT.
>
> Surely this approach is no good: won't it allow hint bits to reach disk
> in advance of their transaction?

I don't think so since it sounds like he's saying to still sync the log and
VACUUM FULL has an exclusive lock on the table. So any committed (or aborted)
changes it sees in the table must have been committed or aborted before the
log sync.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unexpected VACUUM FULL failure
Next
From: Rober Mach
Date:
Subject: pgcheck - data integrity check