Re: automating RangeTblEntry node support
Matthias van de Meent <boekewurm+postgres@gmail.com>
From: Matthias van de Meent <boekewurm+postgres@gmail.com>
To: Paul Jungwirth <pj@illuminatedcomputing.com>
Cc: pgsql-hackers@lists.postgresql.org, Peter Eisentraut <peter@eisentraut.org>
Date: 2024-02-17T23:06:19Z
Lists: pgsql-hackers
On Fri, 16 Feb 2024 at 21:36, Paul Jungwirth <pj@illuminatedcomputing.com> wrote: > > On 1/15/24 02:37, Peter Eisentraut wrote: > > In this updated patch set, I have also added the treatment of the Constraint type. (I also noted > > that the manual read/write functions for the Constraint type are out-of-sync again, so simplifying > > this would be really helpful.) I have also added commit messages to each patch. > > > > The way I have re-ordered the patch series now, I think patches 0001 through 0003 are candidates for > > inclusion after review, patch 0004 still needs a bit more analysis and testing, as described therein. > > Re bloating the serialization output, we could leave this last patch until after the work on that > other thread is done to skip default-valued items. I'm not sure that the cleanup which is done when changing a RTE's rtekind is also complete enough for this purpose. Things like inline_cte_walker change the node->rtekind, which could leave residual junk data in fields that are currently dropped during serialization (as the rtekind specifically ignores those fields), but which would add overhead when the default omission is expected to handle these fields; as they could then contain junk. It looks like there is some care about zeroing now unused fields, but I haven't checked that it covers all cases and fields to the extent required so that removing this specialized serializer would have zero impact on size once the default omission patch is committed. An additional patch with a single function that for this purpose clears junk fields from RTEs that changed kind would be appreciated: it is often hand-coded at those locations the kind changes, but that's more sensitive to programmer error. Kind regards, Matthias van de Meent
Commits
-
Make RangeTblEntry dump order consistent
- b4080fa3dcf6 17.0 landed
-
Remove custom _jumbleRangeTblEntry()
- 367c989cd840 17.0 landed
-
Reformat some node comments
- d575051b9af9 17.0 landed
-
Improve comment
- 1e1eb12c25c3 17.0 landed
-
Remove obsolete comment
- 83d8065b1f74 17.0 landed
-
Remove custom Constraint node read/write implementations
- fbc93b8b5f59 17.0 landed