403 Star 1.4K Fork 1.5K

GVPopenGauss / openGauss-server

 / 详情

合入子查询WIndow函数条件的下推

设计中
需求
创建于  
2024-04-29 08:02

【需求背景】

explain (analyse, buffers)
select * from (
  select row_number() over(partition by c1, c3 order by c2) as rn,
      * from t_winfn
  ) foo
where rn <= 1;

类似上述语句,过滤条件在PG中已经实现下推。

【需求描述】

下推Window函数过滤条件,提前过滤数据,提升更上层算子的执行效率。

【其他说明】

评论 (2)

xiyanziran 创建了需求

Hey @xiyanziran, Welcome to openGauss Community.
All of the projects in openGauss Community are maintained by @opengauss_bot.
That means the developers can comment below every pull request or issue to trigger Bot Commands.
Please follow instructions at Here to find the details.

Hi @xiyanziran, please use the command /sig xxx to add a SIG label to this issue.
For example: /sig sqlengine or /sig storageengine or /sig om or /sig ai and so on.
You can find more SIG labels from Here.
If you have no idea about that, please contact with @xiangxinyong , @zhangxubo .

登录 后才可以发表评论

状态
负责人
项目
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
预计工期 (小时)
参与者(2)
13084139 opengauss bot 1686829535 10572139 vastdata xyzr 1649919805
C++
1
https://gitee.com/opengauss/openGauss-server.git
git@gitee.com:opengauss/openGauss-server.git
opengauss
openGauss-server
openGauss-server

搜索帮助