Commitdd8e191

committed

Consider disk-based hash aggregation to implement DISTINCT.

Correct oversight in1f39bce. If enable_hashagg_disk=true, we shouldconsider hash aggregation for DISTINCT when applicable.

1 parent3649133 commitdd8e191Copy full SHA for dd8e191

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -4868,8 +4868,8 @@ create_distinct_paths(PlannerInfo *root,`
`4868`	`4868`	`Sizehashentrysize=hash_agg_entry_size(`
`4869`	`4869`	`0,cheapest_input_path->pathtarget->width,0);`
`4870`	`4870`
`4871`		`-/* Allow hashing only if hashtable is predicted to fit in work_mem */`
`4872`		`-allow_hash=(hashentrysizenumDistinctRows <=work_mem1024L);`
	`4871`	`+allow_hash=enable_hashagg_disk\|\|`
	`4872`	`+(hashentrysizenumDistinctRows <=work_mem1024L);`
`4873`	`4873`	`}`
`4874`	`4874`
`4875`	`4875`	`if (allow_hash&&grouping_is_hashable(parse->distinctClause))`

Comments

(0)