We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see ourdocumentation.
There was an error while loading.Please reload this page.
1 parente362f46 commitb6c15e7Copy full SHA for b6c15e7
src/backend/optimizer/prep/prepunion.c
@@ -944,11 +944,10 @@ make_union_unique(SetOperationStmt *op, Path *path, List *tlist,
944
945
/*
946
* XXX for the moment, take the number of distinct groups as equal to the
947
- * total input size, ie, the worst case. This is too conservative, but we
948
- * don't want to risk having the hashtable overrun memory; also, it's not
949
- * clear how to get a decent estimate of the true size. One should note
950
- * as well the propensity of novices to write UNION rather than UNION ALL
951
- * even when they don't expect any duplicates...
+ * total input size, ie, the worst case. This is too conservative, but
+ * it's not clear how to get a decent estimate of the true size. One
+ * should note as well the propensity of novices to write UNION rather
+ * than UNION ALL even when they don't expect any duplicates...
952
*/
953
dNumGroups=path->rows;
954