Re: Flaky vacuum truncate test in reloptions.sql

Поиск
Список
Период
Сортировка
От Arseny Sher
Тема Re: Flaky vacuum truncate test in reloptions.sql
Дата
Msg-id 87sg4ar9ar.fsf@ars-thinkpad
обсуждение исходный текст
Ответ на Re: Flaky vacuum truncate test in reloptions.sql  (Masahiko Sawada <sawada.mshk@gmail.com>)
Ответы Re: Flaky vacuum truncate test in reloptions.sql
Re: Flaky vacuum truncate test in reloptions.sql
Список pgsql-hackers
Masahiko Sawada <sawada.mshk@gmail.com> writes:

>> I don't think this matters much, as it tests the contrary and the
>> probability of
>> successful test passing (in case of theoretical bug making vacuum to
>> truncate
>> non-empty relation) becomes stunningly small. But adding it wouldn't hurt
>> either.
>
> I was concerned a bit that without FREEZE in the first VACUUM we could
> not test it properly because the table could not be truncated because
> either vacuum_truncate is off

FREEZE won't help us there.

> or the page is skipped.

You mean at the same time there is a potential bug in vacuum which would
force the truncation of non-empy relation if the page wasn't locked?
That would mean the chance of test getting passed even single time is
close to 0, as currently the chance of its failure is close to 1.


-- cheers, arseny



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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: making update/delete of inheritance trees scale better
Следующее
От: Arseny Sher
Дата:
Сообщение: Re: Flaky vacuum truncate test in reloptions.sql