Re: isolation check takes a long time

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: isolation check takes a long time
Дата
Msg-id 1342218222-sup-8473@alvh.no-ip.org
обсуждение исходный текст
Ответ на isolation check takes a long time  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: isolation check takes a long time  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Excerpts from Andrew Dunstan's message of vie jul 13 16:05:37 -0400 2012:
> Why does the isolation check take such a long time? On some of my slower
> buildfarm members I am thinking of disabling it because it takes so
> long. This single test typically takes longer than a full serial
> standard regression test. Is there any way we could make it faster?

I think the "prepared transactions" test is the one that takes the
longest.  Which is a shame when prepared xacts are not enabled, because
all it does is throw millions of "prepared transactions are not enabled"
errors.  There is one other test that takes very long because it commits
a large amount of transactions.  I found it to be much faster if run
with fsync disabled.

Maybe it'd be a good idea to disable fsync on buildfarm runs, if we
don't already do so?

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCH] lock_timeout and common SIGALRM framework
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCH] lock_timeout and common SIGALRM framework