Re: Testing pg_terminate_backend()

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Testing pg_terminate_backend()
Дата
Msg-id 4020.1208539450@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Testing pg_terminate_backend()  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Testing pg_terminate_backend()  (Magnus Hagander <magnus@hagander.net>)
Re: Testing pg_terminate_backend()  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-patches
Bruce Momjian <bruce@momjian.us> writes:
> Attached is my test script.   I ran it for 14 hours (asserts on),
> running 450 regression tests, with up to seven backends killed per
> regression test.

Hmm, there are something on the order of 10000 SQL commands in our
regression tests, so even assuming perfect randomness you've exercised
SIGTERM on maybe 10% of them --- and of course there's multiple places
in a complex DDL command where SIGTERM might conceivably be a problem.

Who was volunteering to run this 24x7 for awhile?

>         SLEEP=`expr $RANDOM \* $REGRESSION_DURATION / 32767`

Uh, where's the randomness coming from?

            regards, tom lane

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Testing pg_terminate_backend()
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: float4/float8/int64 passed by value with tsearch fixup