Horton

Adjust cost model for HashAgg that spills to disk.

Jeff Davis <jdavis@postgresql.org>

View on postgr.es
Commit: b61d048e0d480f4311c62bf3026879c83ba9aaad
Author: Jeff Davis <jdavis@postgresql.org>
Date: 2020-09-07T20:40:16Z
Releases: 13.0 
Adjust cost model for HashAgg that spills to disk.

Tomas Vondra observed that the IO behavior for HashAgg tends to be
worse than for Sort. Penalize HashAgg IO costs accordingly.

Also, account for the CPU effort of spilling the tuples and reading
them back.

Discussion: https://postgr.es/m/20200906212112.nzoy5ytrzjjodpfh@development
Reviewed-by: Tomas Vondra
Backpatch-through: 13

Files

PathChange+/−
src/backend/optimizer/path/costsize.c modified +13 −0

Discussion