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
|
| Список | 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 по дате отправления: