【需求背景】
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函数过滤条件,提前过滤数据,提升更上层算子的执行效率。
【其他说明】
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 .
登录 后才可以发表评论