Suppressing occasional failures in copy2 regression test

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Suppressing occasional failures in copy2 regression test
Дата
Msg-id 16170.1244910435@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: Suppressing occasional failures in copy2 regression test  (Greg Stark <greg.stark@enterprisedb.com>)
Список pgsql-hackers
Every so often the buildfarm shows row-ordering differences in the copy2
test, for example
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=jaguar&dt=2009-06-13%2003:00:02
("jaguar" seems particularly prone to this for some reason, but other
members have shown it too.)  I believe what is happening is that
autovacuum chances to trigger on the table being used, allowing some of
the updated rows to be placed in positions they're not normally placed
in.

There is a simple fix for that: change the table to be a temp table,
thus preventing autovac from touching it.

Any objections to doing that?
        regards, tom lane


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

Предыдущее
От: kris@shannon.id.au
Дата:
Сообщение: Re: PostgreSQL Developer meeting minutes up
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Suppressing occasional failures in copy2 regression test