Re: Row pattern recognition
Henson Choi <assam258@gmail.com>
From: Henson Choi <assam258@gmail.com>
To: jian he <jian.universality@gmail.com>
Cc: Tatsuo Ishii <ishii@postgresql.org>, zsolt.parragi@percona.com,
sjjang112233@gmail.com, vik@postgresfriends.org, er@xs4all.nl, jacob.champion@enterprisedb.com, david.g.johnston@gmail.com, peter@eisentraut.org, li.evan.chao@gmail.com, pgsql-hackers@postgresql.org
Date: 2026-06-02T22:14:21Z
Lists: pgsql-hackers
Subject: Re: Row pattern recognition
Hi Jian,
> 3.
> 240 variables is enough, as each variable supports multiple complex
> AND/OR conditions. [...] reserving the remaining ones in advance is a
> future-proof approach.
Thanks -- that's (3), and Tatsuo landed on the same choice, so it's
settled. I'll make the change for v48.
> XII-4. Memory Pool Management
> Choice: Custom free list [...]
> It would be better simply to mention that:
> RPRNFAState and RPRNFAContext are allocated in a partition-lifespan
> memory context; they will be destroyed in release_partition.
Agreed -- that's clearer than the rationale list. I'll replace XII-4 with
that wording.
> If ctx->matchedState points to one of the states already in ctx->states,
> will nfa_state_free() be called on the same RPRNFAState twice? Is this
> double-free permitted, or do we have a mechanism in place to guard
> against it?
No -- they're disjoint by construction, so the two frees never touch the
same state. Step by step:
- nfa_advance() detaches ctx->states up front (sets it to NULL) and
rebuilds the list from scratch.
- Each old state is pulled off and advanced; the one that reaches FIN is
moved into matchedState and never re-added to ctx->states.
- So at any moment a state is either on ctx->states or it is
matchedState, never both.
- ExecRPRFreeContext frees the list and frees matchedState -- disjoint
sets, no overlap, so no guard is needed.
- (When a new FIN replaces matchedState, the previous one is freed right
there.)
> if (currentPos == ctxFrameEnd) {
> nfa_match(winstate, ctx, NULL);
> continue;
> }
> If I comment out the CONTINUE, the entire regression still succeeds.
It isn't dead -- it's the N-FOLLOWING boundary handler. nfa_match(ctx,
NULL) forces a mismatch that finalizes the context on its matchedState,
and the continue skips the rest since it's done for this row.
Without the continue, that finalized context is matched a second time in
the same row -- a context-matched-twice error. It only looks harmless
because the forced mismatch already emptied ctx->states, so the second
nfa_match iterates nothing (and it would also re-run
nfa_reevaluate_dependent_vars(), overwriting the shared nfaVarMatched the
other contexts read). So I'd keep it: a finalized context must not be
matched twice in the same row.
Thanks,
Henson
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