Commitb05ee92

committed

add PickyAppend user GUC

1 parent081c4ee commitb05ee92Copy full SHA for b05ee92

File tree

+19

-1

lines changed

+19

-1

lines changed

Lines changed: 12 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -33,6 +33,7 @@`
`33`	`33`	`#include"utils/date.h"`
`34`	`34`	`#include"utils/typcache.h"`
`35`	`35`	`#include"utils/lsyscache.h"`
	`36`	`+#include"utils/guc.h"`
`36`	`37`	`#include"access/heapam.h"`
`37`	`38`	`#include"access/nbtree.h"`
`38`	`39`	`#include"storage/ipc.h"`
`@@ -157,6 +158,17 @@ _PG_init(void)`
`157`	`158`	`pickyappend_exec_methods.MarkPosCustomScan=NULL;`
`158`	`159`	`pickyappend_exec_methods.RestrPosCustomScan=NULL;`
`159`	`160`	`pickyappend_exec_methods.ExplainCustomScan=pickyppend_explain;`
	`161`	`+`
	`162`	`+DefineCustomBoolVariable("pg_pathman.enable_pickyappend",`
	`163`	`+"Enables the planner's use of PickyAppend custom node.",`
	`164`	`+NULL,`
	`165`	`+&pg_pathman_enable_pickyappend,`
	`166`	`+ true,`
	`167`	`+PGC_USERSET,`
	`168`	`+0,`
	`169`	`+NULL,`
	`170`	`+NULL,`
	`171`	`+NULL);`
`160`	`172`	`}`
`161`	`173`
`162`	`174`	`void`

Lines changed: 4 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -10,6 +10,9 @@`
`10`	`10`	`#include"optimizer/tlist.h"`
`11`	`11`	`#include"optimizer/var.h"`
`12`	`12`
	`13`	`+`
	`14`	`+boolpg_pathman_enable_pickyappend= true;`
	`15`	`+`
`13`	`16`	`set_join_pathlist_hook_typeset_join_pathlist_next=NULL;`
`14`	`17`
`15`	`18`	`CustomPathMethodspickyappend_path_methods;`
`@@ -293,7 +296,7 @@ pathman_join_pathlist_hook(PlannerInfo *root,`
`293`	`296`	`set_join_pathlist_next(root,joinrel,outerrel,`
`294`	`297`	`innerrel,jointype,extra);`
`295`	`298`
`296`		`-if (jointype==JOIN_FULL)`
	`299`	`+if (jointype==JOIN_FULL\|\| !pg_pathman_enable_pickyappend)`
`297`	`300`	`return;`
`298`	`301`
`299`	`302`	`if (innerrel->reloptkind==RELOPT_BASEREL&&`

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -6,6 +6,9 @@`
`6`	`6`
`7`	`7`	`#include"pathman.h"`
`8`	`8`
	`9`	`+`
	`10`	`+externboolpg_pathman_enable_pickyappend;`
	`11`	`+`
`9`	`12`	`typedefstruct`
`10`	`13`	`{`
`11`	`14`	`Oidrelid;`

Comments

(0)