Re: Weird failure in explain.out with OpenBSD

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Weird failure in explain.out with OpenBSD
Дата
Msg-id
2196833.1609276566@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Weird failure in explain.out with OpenBSD Michael Paquier <michael@paquier.xyz>
Re: Weird failure in explain.out with OpenBSD Tom Lane <tgl@sss.pgh.pa.us>
Re: Weird failure in explain.out with OpenBSD Tom Lane <tgl@sss.pgh.pa.us>
Re: Weird failure in explain.out with OpenBSD Michael Paquier <michael@paquier.xyz>
Re: Weird failure in explain.out with OpenBSD Thomas Munro <thomas.munro@gmail.com>
Re: Weird failure in explain.out with OpenBSD Michael Paquier <michael@paquier.xyz>
Re: Weird failure in explain.out with OpenBSD Mikael Kjellström <mikael.kjellstrom@mksoft.nu>
Re: Weird failure in explain.out with OpenBSD Thomas Munro <thomas.munro@gmail.com>
Re: Weird failure in explain.out with OpenBSD Andres Freund <andres@anarazel.de>
Re: Weird failure in explain.out with OpenBSD Mikael Kjellström <mikael.kjellstrom@mksoft.nu>
Re: Weird failure in explain.out with OpenBSD Mikael Kjellström <mikael.kjellstrom@mksoft.nu>
Re: Weird failure in explain.out with OpenBSD Mikael Kjellström <mikael.kjellstrom@mksoft.nu>
I wrote:
> ... so my guess is that something messed up in transmitting or combining a
> parallel worker's execution time.

Hmph, no, a look at explain.c shows that the "Execution Time" is just
based on the difference of INSTR_TIME_SET_CURRENT measurements taken
within the current process.  It's difficult to conclude anything except
that the clock went backwards.  Which is weird, because according to [1]
that system does have clock_gettime(CLOCK_MONOTONIC), which'd be our
preferred choice of INSTR_TIME time base; and such clocks are not
supposed to go backwards ever.

Tis puzzling, but it's hard to avoid the suspicion of a kernel bug.

			regards, tom lane

[1] https://man.openbsd.org/OpenBSD-6.8/clock_gettime


В списке pgsql-hackers по дате отправления
От: David Rowley
Дата:
От: Tom Lane
Дата:
Сообщение: Re: Let's start using setenv()
FAQ