pgsql: Report sort phase progress in parallel btree build

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема pgsql: Report sort phase progress in parallel btree build
Дата
Msg-id E1lrqGL-0000W0-Kg@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Report sort phase progress in parallel btree build

We were already reporting it, but only after the parallel workers were
finished, which is visibly much later than what happens in a serial
build.

With this change we report it when the leader starts its own sort phase
when participating in the build (the normal case).  Now this might
happen a little later than when the workers start their sorting phases,
but a) communicating the actual phase start from workers is likely to be
a hassle, and b) the sort phase start is pretty fuzzy anyway, since
sorting per se is actually initiated by tuplesort.c internally earlier
than tuplesort_performsort() is called.

Backpatch to pg12, where the progress reporting code for CREATE INDEX
went in.

Reported-by: Tomas Vondra <tomas.vondra@enterprisedb.com>
Author: Matthias van de Meent <boekewurm+postgres@gmail.com>
Reviewed-by: Greg Nancarrow <gregn4422@gmail.com>
Reviewed-by: Álvaro Herrera <alvherre@alvh.no-ip.org>
Discussion: https://postgr.es/m/1128176d-1eee-55d4-37ca-e63644422adb

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/5cc1cd502879d642da799e1fd12619d83d987369

Modified Files
--------------
src/backend/access/nbtree/nbtsort.c | 17 ++++++++++-------
1 file changed, 10 insertions(+), 7 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Fix multiple crasher bugs in partitioned-table replication logic
Следующее
От: Bruce Momjian
Дата:
Сообщение: pgsql: docs: fix incorrect indenting in PG 14 relnotes