pgsql: Make EXPLAIN report maximum hashtable usage across multiple resc
От | Tom Lane |
---|---|
Тема | pgsql: Make EXPLAIN report maximum hashtable usage across multiple resc |
Дата | |
Msg-id | E1jNJAL-0000Cb-Ip@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Make EXPLAIN report maximum hashtable usage across multiple rescans. Before discarding the old hash table in ExecReScanHashJoin, capture its statistics, ensuring that we report the maximum hashtable size across repeated rescans of the hash input relation. We can repurpose the existing code for reporting hashtable size in parallel workers to help with this, making the patch pretty small. This also ensures that if rescans happen within parallel workers, we get the correct maximums across all instances. Konstantin Knizhnik and Tom Lane, per diagnosis by Thomas Munro of a trouble report from Alvaro Herrera. Discussion: https://postgr.es/m/20200323165059.GA24950@alvherre.pgsql Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/969f9d0b4ba574bb8df65683dbf7a09c030f3e67 Modified Files -------------- src/backend/commands/explain.c | 46 +++++++++++------------------ src/backend/executor/nodeHash.c | 58 ++++++++++++++++++++++++++++--------- src/backend/executor/nodeHashjoin.c | 10 ++++++- src/include/executor/nodeHash.h | 4 +-- src/include/nodes/execnodes.h | 18 ++++++++++-- 5 files changed, 87 insertions(+), 49 deletions(-)
В списке pgsql-committers по дате отправления: