Re: Silent overflow of interval type

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Silent overflow of interval type
Дата
Msg-id 2155716.1676506365@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Silent overflow of interval type  (Andrey Borodin <amborodin86@gmail.com>)
Ответы Re: Silent overflow of interval type  (Nick Babadzhanian <pgnickb@gmail.com>)
Список pgsql-hackers
Andrey Borodin <amborodin86@gmail.com> writes:
> On Wed, Feb 15, 2023 at 7:08 AM Nikolai <pgnickb@gmail.com> wrote:
>> The patch attached simply throws an error when an overflow is
>> detected. However I'm not sure this is a reasonable approach for a
>> code path that could be very hot in some workloads.

> Given the extraordinary amount of overflow checks in the nearby code
> of timestamp.c, I'd say that this case should not be an exception.

Yeah, I don't think this would create a performance problem, at least not
if you're using a compiler that implements pg_sub_s64_overflow reasonably.
(And if you're not, and this bugs you, the answer is to get a better
compiler.)

> By chance did you look at all other nearby cases, is it the only place
> with overflow?

That was my immediate reaction as well.

            regards, tom lane



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

Предыдущее
От: Nathan Bossart
Дата:
Сообщение: Re: DDL result is lost by CREATE DATABASE with WAL_LOG strategy
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Normalization of utility queries in pg_stat_statements