Re: Reduce build times of pg_trgm GIN indexes
Peter Eisentraut <peter@eisentraut.org>
From: Peter Eisentraut <peter@eisentraut.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Heikki Linnakangas <hlinnaka@iki.fi>, David Geier <geidav.pg@gmail.com>,
Matthias van de Meent <boekewurm+postgres@gmail.com>,
pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2026-04-16T08:45:55Z
Lists: pgsql-hackers
On 15.04.26 23:25, Tom Lane wrote: > Peter Eisentraut <peter@eisentraut.org> writes: >> On 15.04.26 13:06, Heikki Linnakangas wrote: >>> This was briefly discussed when PointerGetDatum() was changed from a >>> macro to a static inline function [1]. On that email, Peter pointed out >>> that the compiler was doing the same deduction that Coverity did now, >>> i.e. that if you pass the Datum returned by PointerGetDatum(&foo) to a >>> function, it cannot change *foo. I'm surprised we dismissed that worry >>> so quickly. If the compiler optimizes based on that assumption, you can >>> get incorrect code. > >> I don't think this is in evidence. AFAICT, it's just Coverity that is >> complaining here, which is its right, but the code is not incorrect. > > Are you sure? This seems like the sort of thing that will bite us on > the rear sometime in the future, as the compiler geeks put in more and > more aggressive optimizations. > > I think we should at least test the theory that changing > PointerGetDatum to remove the const cast would silence Coverity's > complaint. If it does not then we're attributing too much > intelligence to Coverity. But if it does, then we've correctly > identified why it's complaining, and we should take seriously the > idea that they aren't the only ones making this sort of deduction > (or won't be for long). I think it's quite clear to me that Coverity is complaining about this correctly, in its view of the world. Compilers sometimes complain about this, too, although in this case they apparently don't look quite as deeply to do this analysis. What I'm missing here is, essentially where the previous thread stopped: What is the overall message that we want to communicate with the API? If the default assumption is that what pointers converted to Datums point to should not be modified on the other side (where the Datum is converted back to a pointer), then the current declaration of PointerGetDatum() is suitable, and the GIN code can be considered an exception and we make a special API for that. The previous thread proposed NonconstPointerGetDatum(). (If this is the resolution, I also have half a patch somewhere that makes the string input argument for the InputFunctionCall family of functions const, which also seems intuitively sensible.) If, on the other hand, the decision is that there is in fact no such guarantee, that consumers of Datums are free to modify whatever they seem fit, then we should drop the const of PointerGetDatum and fix the fallout up the call stack. The macro proposed by Heikki, I don't know, still doesn't actually answer this question, just (possibly) makes these warnings go away in a slightly mysterious way.
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Change PointerGetDatum() back to a macro
- d65995cbc6e1 19 (unreleased) landed
-
Replace deprecated StaticAssertStmt() with StaticAssertDecl()
- 66ad764c8d51 19 (unreleased) landed
-
Optimize sorting and deduplicating trigrams
- 9f3755ea07aa 19 (unreleased) landed
-
Optimize sort and deduplication in ginExtractEntries()
- 6f5ad00ab763 19 (unreleased) landed
-
Inline ginCompareAttEntries for speed
- bba81f9d3d4f 19 (unreleased) landed