Skip to content

Files

Latest commit

Dec 15, 2023
f400df2 · Dec 15, 2023

History

History
68 lines (41 loc) · 2.95 KB

20210707_01.md

File metadata and controls

68 lines (41 loc) · 2.95 KB

PostgreSQL 15 preview - Allow CustomScan providers to say whether they support projections.

作者

digoal

日期

2021-07-07

标签

PostgreSQL , customscan provider , projection


背景

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=955b3e0f9269639fb916cee3dea37aee50b82df0

Allow CustomScan providers to say whether they support projections.  
author	Tom Lane <tgl@sss.pgh.pa.us>	  
Tue, 6 Jul 2021 22:10:11 +0000 (18:10 -0400)  
committer	Tom Lane <tgl@sss.pgh.pa.us>	  
Tue, 6 Jul 2021 22:10:20 +0000 (18:10 -0400)  
commit	955b3e0f9269639fb916cee3dea37aee50b82df0  
tree	395cf4010f26d0e3f2383f9ad724cb683135acce	tree  
parent	5798ca529935698ab976780565fb2b4d8d34d810	commit | diff  
Allow CustomScan providers to say whether they support projections.  
  
Previously, all CustomScan providers had to support projections,  
but there may be cases where this is inconvenient.  Add a flag  
bit to say if it's supported.  
  
Important item for the release notes: this is non-backwards-compatible  
since the default is now to assume that CustomScan providers can't  
project, instead of assuming that they can.  It's fail-soft, but could  
result in visible performance penalties due to adding unnecessary  
Result nodes.  
  
Sven Klemm, reviewed by Aleksander Alekseev; some cosmetic fiddling  
by me.  
  
Discussion: https://postgr.es/m/CAMCrgp1kyakOz6c8aKhNDJXjhQ1dEjEnp+6KNT3KxPrjNtsrDg@mail.gmail.com  

您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议,奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等,奖品丰富,快来许愿。开不开森.

digoal's wechat