pgsql: Adjust cost model for HashAgg that spills to disk.

From: Jeff Davis <jdavis(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Adjust cost model for HashAgg that spills to disk.
Date: 2020-09-07 20:39:56
Message-ID: E1kFNvg-0004OC-5D@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/a547e6867527ca16628a3fb1cf3ef6f785210a31

Modified Files
--------------
src/backend/optimizer/path/costsize.c | 13 +++++++++++++
1 file changed, 13 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Jeff Davis 2020-09-07 20:45:22 pgsql: Adjust cost model for HashAgg that spills to disk.
Previous Message Tom Lane 2020-09-07 18:52:42 pgsql: Clarify comments in enforce_generic_type_consistency().