Re: Reduce build times of pg_trgm GIN indexes

On 08.04.2026 04:15, John Naylor wrote:
> On Tue, Apr 7, 2026 at 6:27 PM Heikki Linnakangas <hlinnaka(at)iki(dot)fi> wrote:
>> But the comments on the pg_cmp functions say:
>>
>>> * NB: If the comparator function is inlined, some compilers may produce
>>> * worse code with these helper functions than with code with the
>>> * following form:
>>> *
>>> * if (a < b)
>>> * return -1;
>>> * if (a > b)
>>> * return 1;
>>> * return 0;
>>> *
>>
>> So, uh, is that really a universal improvement? Is that comment about
>> producing worse code outdated?

Well spotted. Thanks!

>
> No, it's quite recent:
>
> https://www.postgresql.org/message-id/20240212230423.GA3519%40nathanxps13

In my original benchmarks it was faster. I'll rebase the remaining
commits and do some more analysis.

--
David Geier