Re: CF entries for 17 to be reviewed - Mailing list pgsql-hackers

From Andrey M. Borodin
Subject Re: CF entries for 17 to be reviewed
Date
Msg-id 28B4FE0B-A082-461F-B32B-C9A06DABC09A@yandex-team.ru
Whole thread Raw
In response to Re: CF entries for 17 to be reviewed  ("Andrey M. Borodin" <x4mmm@yandex-team.ru>)
Responses Re: CF entries for 17 to be reviewed
List pgsql-hackers

> On 6 Mar 2024, at 18:49, Andrey M. Borodin <x4mmm@yandex-team.ru> wrote:
>
> Here are statuses for "Refactoring" section:

I've made a pass through "Replication and Recovery" and "SQL commands" sections.
"SQL commands" section seems to me most interesting stuff on the commitfest (but I'm far from inspecting every thing
threadyet). But reviewing patches from this section is not a work for one CF definitely. Be prepared that this is a
longrun, with many iterations and occasional architectural pivots. Typically reviewers work on these items for much
morethan one month. 

Replication and Recovery
* Synchronizing slots from primary to standby
    Titanic work. A lot of stuff already pushed, v108 is now in the discussion. ISTM that entry barrier of jumping into
discussionwith something useful is really high. 
* CREATE SUBSCRIPTION ... SERVER
    The discussion stopped in January. Authors posted new version recently.
* speed up a logical replication setup (pg_createsubscriber)
    Newest version posted recently, but it fails CFbot's tests. Pinged authors.
* Have pg_basebackup write "dbname" in "primary_conninfo"?
    Some feedback and descussin provided. Switched to WoA.

SQL Commands
* Add SPLIT PARTITION/MERGE PARTITIONS commands
    Cool new commands, very useful for sharding. CF item was RfC recently, need review update after rebase.
* Add CANONICAL option to xmlserialize
    Vignesh C and Chapman Flack provided some feedback back in October 2023, but the patch still needs review.
* Incremental View Maintenance
    This is a super cool feature. IMO at this point is too late for 17, but you should consider reviewing this not
becauseit's easy, but because it's hard. It's real rocket science. Fine-grained 11-step patchset, which can change a
lotof workloads if committed. CFbot finds some failures, but this should not stop anyone frome reviewing in this case. 
* Implement row pattern recognition feature
    SQL:2016 feature, carefully split into 8 steps. Needs review, probably review in a long run. The feature seems big.
3reviewers are working on this, but no recent input for some months. 
* COPY TO json
    Active thread with many different authors proposing different patches. I could not summarize it, asked CF entry
authorfor help. 
* Add new error_action COPY ON_ERROR "log"
    There's an active discussion in the thread.
* add COPY option RECECT_LIMIT
    While the patch seems much similar to previous, there's no discussion in this thread...

Thanks!


Best regards, Andrey Borodin.


pgsql-hackers by date:

Previous
From: Melanie Plageman
Date:
Subject: Re: Confine vacuum skip logic to lazy_scan_skip
Next
From: Joe Conway
Date:
Subject: Re: Emitting JSON to file using COPY TO