Fix LookupTupleHashEntryHash() pipeline-stall issue.
Jeff Davis <jdavis@postgresql.org>
Fix LookupTupleHashEntryHash() pipeline-stall issue. Refactor hash lookups in nodeAgg.c to improve performance. Author: Andres Freund and Jeff Davis Discussion: https://postgr.es/m/20200612213715.op4ye4q7gktqvpuo%40alap3.anarazel.de Backpatch-through: 13
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/executor/execGrouping.c | modified | +19 −10 |
| src/backend/executor/nodeAgg.c | modified | +79 −84 |
| src/backend/executor/nodeRecursiveunion.c | modified | +2 −2 |
| src/backend/executor/nodeSetOp.c | modified | +2 −2 |
| src/backend/executor/nodeSubplan.c | modified | +2 −2 |
| src/include/executor/executor.h | modified | +1 −1 |
Discussion
- hashagg slowdown due to spill changes 31 messages · 2020-06-06 → 2020-07-27