progress reporting for partitioned REINDEX

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема progress reporting for partitioned REINDEX
Дата
Msg-id 20210216064214.GI28165@telsasoft.com
обсуждение исходный текст
Ответы Re: progress reporting for partitioned REINDEX  (Matthias van de Meent <boekewurm+postgres@gmail.com>)
Список pgsql-hackers
It looks like we missed this in a6642b3ae.

I think it's an odd behavior of pg_stat_progress_create_index to simultaneously
show the global progress as well as the progress for the current partition ...

It seems like for partitioned reindex, reindex_index() should set the AM, which
is used in the view:

src/backend/catalog/system_views.sql-                       WHEN 2 THEN 'building index' ||
src/backend/catalog/system_views.sql:                           COALESCE((': ' ||
pg_indexam_progress_phasename(S.param9::oid,S.param11)),
 

Maybe it needs a new flag, like:
params->options & REINDEXOPT_REPORT_PROGRESS_AM

I don't understand why e66bcfb4c added multiple calls to
pgstat_progress_start_command().

-- 
Justin

Вложения

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: libpq PQresultErrorMessage vs PQerrorMessage API issue
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: ERROR: invalid spinlock number: 0