Re: Improving and extending int128.h to more of numeric.c

From: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
To: John Naylor <johncnaylorls(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Improving and extending int128.h to more of numeric.c
Date: 2025-07-14 21:07:38
Message-ID: CAEZATCUvsykfgmwKysrp86_MbLV8FTjOGXHXzS5UFrc6b2=1ew@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 14 Jul 2025 at 11:22, John Naylor <johncnaylorls(at)gmail(dot)com> wrote:
>
> (Looking at v3) The new test module runs 10 million rather than a
> billion iterations. That still takes 1.2s (after 0005), which seems
> excessive for regular buildfarm testing. It seems like we could get by
> with fewer than that, by using the time of day for the PRNG seed
> (which would also need to be logged on error).

Thanks for looking!

I have reduced the number of iterations and changed it to use the
current time for the PRNG seed. I don't see much value in logging the
seed though, since we already log the inputs that cause any failure.

> > 0005 is the main patch.
> >
> I haven't looked too closely, but wanted to point out:
>
> warning: format ‘%lX’ expects argument of type ‘long unsigned int’,
> but argument 4 has type ‘int32’ {aka ‘int’} [-Wformat=]
>
> ...

Ah yes, thanks for pointing that out.

(The cfbot reports the same warnings, but you have to scroll through a
lot of output to see them. It would be nice if the commitfest app had
an indicator to show if there were any compiler warnings.)

v4 attached.

Regards,
Dean

Attachment Content-Type Size
v4-0001-Convert-src-tools-testint128.c-into-a-test-module.patch text/x-patch 7.2 KB
v4-0004-Simplify-non-native-64x64-bit-multiplication-in-i.patch text/x-patch 3.4 KB
v4-0005-Extend-int128.h-to-support-more-numeric-code.patch text/x-patch 38.1 KB
v4-0003-Optimise-non-native-128-bit-addition-in-int128.h.patch text/x-patch 3.3 KB
v4-0002-Refactor-int128.h-bringing-the-native-and-non-nat.patch text/x-patch 5.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2025-07-14 21:21:23 Re: Inline non-SQL SRFs using SupportRequestSimplify
Previous Message Sami Imseih 2025-07-14 20:45:02 Re: Improve LWLock tranche name visibility across backends