Push down Modifying CTEs with INSERT
Open
performance
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
#3654 implemented pushdown for modifying CTEs containing UPDATE or DELETE commands that prune to the same shards. We should do the same for modifying CTEs containing INSERT.
Contributor guide
Research direction
Start by reading issue #3654 and the existing pushdown implementation for modifying CTEs containing UPDATE or DELETE. Trace how shard pruning is handled, then identify the corresponding INSERT path; done means INSERT CTEs with the same-shard pruning condition are pushed down consistently.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- c, postgresql, sql
- Domain
- databases, distributed-systems
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100