Re: Reduce build times of pg_trgm GIN indexes - Mailing list pgsql-hackers

From David Geier
Subject Re: Reduce build times of pg_trgm GIN indexes
Date
Msg-id 27e8142d-19da-48a8-8eac-7b2e117dc463@gmail.com
Whole thread
In response to Re: Reduce build times of pg_trgm GIN indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 12.04.2026 20:05, Tom Lane wrote:
> Heikki Linnakangas <hlinnaka@iki.fi> writes:
>> Pushed 0001 as commit 6f5ad00ab7.
> 
> This commit has caused Coverity to start complaining that
> most of ginExtractEntries() is unreachable:
> 
> *** CID 1691468:         Control flow issues  (DEADCODE)
> /srv/coverity/git/pgsql-git/postgresql/src/backend/access/gin/ginutil.c: 495             in ginExtractEntries()
> 489         /*
> 490          * Scan the items for any NULLs.  All NULLs are considered equal, so we
> 491          * just need to check and remember if there are any.  We remove them from
> 492          * the array here, and after deduplication, put back one NULL entry to
> 493          * represent them all.
> 494          */
>>>>     CID 1691468:         Control flow issues  (DEADCODE)
>>>>     Execution cannot reach this statement: "hasNull = false;".
> 495         hasNull = false;
> 496         if (nullFlags)
> 497         {
> 498             int32        numNonNulls = 0;
> 499     
> 500             for (int32 i = 0; i < nentries; i++)
> 
> Evidently, it does not realize that the extractValueFn() can change
> nentries from its initial value of zero.  I wouldn't be too surprised
> if that's related to our casting of the pointer to uintptr_t --- that
> may cause it to not see the passed pointer as a potential reference
> mechanism.

Curious that we don't see that more frequently for other functions that
have output arguments. But maybe there are just too few?

> I would just write that off as Coverity not being smart enough, except
> that I'm worried that some compiler might make a similar deduction and
> break the function completely.  Was the switch to a local variable
> for nentries really a useful win performance-wise?

I haven't benchmarked the variant with using the pointer directly. I can
do that.

--
David Geier



pgsql-hackers by date:

Previous
From: Kirill Reshke
Date:
Subject: Re: DELETE/UPDATE FOR PORTION OF with rule system is not working
Next
From: Robert Haas
Date:
Subject: Re: pg_plan_advice