Re: Row pattern recognition
Tatsuo Ishii <ishii@postgresql.org>
From: Tatsuo Ishii <ishii@postgresql.org>
To: assam258@gmail.com
Cc: jacob.champion@enterprisedb.com, david.g.johnston@gmail.com,
vik@postgresfriends.org, er@xs4all.nl, peter@eisentraut.org,
pgsql-hackers@postgresql.org
Date: 2026-02-04T10:22:22Z
Lists: pgsql-hackers
Hi Henson, > Therefore, I believe it only makes sense to add explicit initialization > for nfaStatesActive and nfaContextsActive, since these are the only two > that release_partition() also explicitly resets. That makes sense. > Adding explicit > initialization for all the cumulative statistics would be misleading, > as it might suggest they get reset somewhere (which they don't). > > ## Proposal for consistency > > For consistency with release_partition(), I can add just the two > per-partition counter initializations to ExecInitWindowAgg(): > > /* Initialize NFA free lists for row pattern matching */ > winstate->nfaContext = NULL; > winstate->nfaContextTail = NULL; > winstate->nfaContextFree = NULL; > winstate->nfaStateFree = NULL; > winstate->nfaLastProcessedRow = -1; > winstate->nfaStatesActive = 0; // Add this > winstate->nfaContextsActive = 0; // Add this > > This would make both ExecInitWindowAgg() and release_partition() > initialize the same set of per-partition NFA fields, making the code > more uniform and easier to review. The cumulative statistics fields > remain omitted in both functions, which correctly reflects that they > are never reset. > > Functionally, this change makes no difference since palloc0() already > zeros these fields, but it improves code consistency and makes the > per-partition vs. query-wide distinction clearer. > > Would you like me to include this change in the next patch? Yes, please. Best regards, -- Tatsuo Ishii SRA OSS K.K. English: http://www.sraoss.co.jp/index_en/ Japanese:http://www.sraoss.co.jp
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Adjust cross-version upgrade tests for seg_out() fix
- 3e3d7875e956 19 (unreleased) cited
-
Rationalize error comments in partition split/merge tests
- ecb2508aaf9b 19 (unreleased) cited
-
Add fast path for foreign key constraint checks
- 2da86c1ef9b5 19 (unreleased) cited
-
Fix assorted pretty-trivial memory leaks in the backend.
- e78d1d6d47dc 19 (unreleased) cited
-
Add temporal FOREIGN KEY contraints
- 89f908a6d0ac 18.0 cited
-
Add trailing commas to enum definitions
- 611806cd726f 17.0 cited
-
Remove obsolete executor cleanup code
- d060e921ea5a 17.0 cited