Enable partial sort optimization for any index scan

knizhnik · knizhnik · commit 45e88b5f99bd · 2016-02-07T12:17:44.000+03:00
diff --git a/src/backend/optimizer/path/pathkeys.c b/src/backend/optimizer/path/pathkeys.c
@@ -443,7 +443,7 @@ get_cheapest_partial_path_for_pathkeys(List *paths,
 	{
 		Path	   *path = (Path *) lfirst(l);
 		int prefix_len = pathkeys_get_prefix(pathkeys, path->pathkeys);
-		if (prefix_len < best_prefix_len || path->pathtype != T_IndexOnlyScan) { 
+		if (prefix_len < best_prefix_len) { 
 			continue;
 		}
 		/*

Original file line number	Diff line number	Diff line change
`@@ -443,7 +443,7 @@ get_cheapest_partial_path_for_pathkeys(List *paths,`
`443`	`443`	`{`
`444`	`444`	`Path path = (Path ) lfirst(l);`
`445`	`445`	`int prefix_len = pathkeys_get_prefix(pathkeys, path->pathkeys);`
`446`		`- if (prefix_len < best_prefix_len \|\| path->pathtype != T_IndexOnlyScan) {`
	`446`	`+ if (prefix_len < best_prefix_len) {`
`447`	`447`	`continue;`
`448`	`448`	`}`
`449`	`449`	`/*`