Re: Intermittent buildfarm failures on wrasse

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Intermittent buildfarm failures on wrasse
Дата
Msg-id 20220414003502.fmcm3wcgjw5zk5ax@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: Intermittent buildfarm failures on wrasse  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
Hi,

On 2022-04-13 16:45:44 -0700, Peter Geoghegan wrote:
> On Wed, Apr 13, 2022 at 4:38 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > So what seems to be happening on wrasse is that a background
> > autovacuum (or really autoanalyze?) is preventing pages from
> > being marked all-visible not only during test_setup.sql but
> > also create_index.sql; but it's gone by the time sanity_check.sql
> > runs.
> 
> I agree that it would need to be an autoanalyze (due to the
> PROC_IN_VACUUM optimization).

That's not a realiable protection - the snapshot is established normally
at first, only after a while we set PROC_IN_VACUUM...

Greetings,

Andres Freund



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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: typos
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Intermittent buildfarm failures on wrasse