Re: Unexpected VACUUM FULL failure

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: Unexpected VACUUM FULL failure
Дата
Msg-id 874pj8rrhe.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: Unexpected VACUUM FULL failure  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Unexpected VACUUM FULL failure
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Unexpected VACUUM FULL failure
Следующее
От: Rober Mach
Дата:
Сообщение: pgcheck - data integrity check