Re: Proposed patch for 8.3 VACUUM FULL crash

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Proposed patch for 8.3 VACUUM FULL crash
Дата
Msg-id 9865.1202765568@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Proposed patch for 8.3 VACUUM FULL crash  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-patches
Gregory Stark <stark@enterprisedb.com> writes:
> "Tom Lane" <tgl@sss.pgh.pa.us> writes:
>> On investigation the problem occurs because we changed vacuum.c's
>> PageGetFreeSpaceWithFillFactor() to use PageGetHeapFreeSpace()
>> instead of just computing pd_upper - pd_lower as it had done in
>> every previous release.  This was *not* a good idea: VACUUM FULL
>> does its own accounting for line pointers and does not need "help".

> Fwiw this change appears to have crept in when the patch was merged.

Yeah, it's entirely likely that this was my fault :-(.  It wasn't
apparent at the time that this change wasn't safe and conservative...

            regards, tom lane

В списке pgsql-patches по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: Proposed patch for 8.3 VACUUM FULL crash
Следующее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: tzcode update