Propagate sort instrumentation from workers back to leader.
Robert Haas <rhaas@postgresql.org>
Propagate sort instrumentation from workers back to leader. Up until now, when parallel query was used, no details about the sort method or space used by the workers were available; details were shown only for any sorting done by the leader. Fix that. Commit 1177ab1dabf72bafee8f19d904cee3a299f25892 forced the test case added by commit 1f6d515a67ec98194c23a5db25660856c9aab944 to run without parallelism; now that we have this infrastructure, allow that again, with a little tweaking to make it pass with and without force_parallel_mode. Robert Haas and Tom Lane Discussion: http://postgr.es/m/CA+Tgmoa2VBZW6S8AAXfhpHczb=Rf6RqQ2br+zJvEgwJ0uoD_tQ@mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/commands/explain.c | modified | +54 −3 |
| src/backend/executor/execParallel.c | modified | +89 −66 |
| src/backend/executor/nodeSort.c | modified | +97 −0 |
| src/backend/utils/sort/tuplesort.c | modified | +43 −13 |
| src/include/executor/nodeSort.h | modified | +7 −0 |
| src/include/nodes/execnodes.h | modified | +12 −0 |
| src/include/utils/tuplesort.h | modified | +31 −3 |
| src/test/regress/expected/subselect.out | modified | +4 −1 |
| src/test/regress/sql/subselect.sql | modified | +5 −1 |
Discussion
- [PATCH] Push limit to sort through a subquery 50 messages · 2017-04-19 → 2017-08-25