RE: [DOC] Fix for the missing pg_stat_progress_cluster view phasecolumn value

Поиск
Список
Период
Сортировка
От Shinoda, Noriyoshi (PN Japan A&PS Delivery)
Тема RE: [DOC] Fix for the missing pg_stat_progress_cluster view phasecolumn value
Дата
Msg-id AT5PR8401MB0644B1826C90AB2B80BA4522EE660@AT5PR8401MB0644.NAMPRD84.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на Re: [DOC] Fix for the missing pg_stat_progress_cluster view phasecolumn value  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Список pgsql-hackers
Thank you for your response.

> By the way the table mentions the phases common to CLUSTER and VACUUM FULL. I wonder why some of them are described
as"CLUSTER is" and others are "The command is".. 

The 'writing new heap' phase seems to appear only when the CLUSTER statement is executed. When I read the
table_relation_copy_for_clusterfunction, it seems to be a phase that is executed only during sorting. 

Regards,
Noriyoshi Shinoda

-----Original Message-----
From: Kyotaro Horiguchi [mailto:horikyota.ntt@gmail.com]
Sent: Monday, October 28, 2019 2:27 PM
To: Shinoda, Noriyoshi (PN Japan A&PS Delivery) <noriyoshi.shinoda@hpe.com>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: [DOC] Fix for the missing pg_stat_progress_cluster view phase column value

At Sat, 26 Oct 2019 05:13:49 +0000, "Shinoda, Noriyoshi (PN Japan A&PS Delivery)" <noriyoshi.shinoda@hpe.com> wrote in
> I found a missing column value in the pg_stat_progress_cluster view document.
> I read the src/backend/catalog/system_views.sql file, there seems to be a possibility that 'writing new heap' is
outputin the 'phase' column. 
> The attached patch adds a description of the 'writing new heap' value output in the 'phase' column.

Good catch!

By the way the table mentions the phases common to CLUSTER and VACUUM FULL. I wonder why some of them are described as
"CLUSTERis" and others are "The command is".. 

regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center



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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: [PATCH] Do not use StdRdOptions in Access Methods
Следующее
От: Dilip Kumar
Дата:
Сообщение: Re: [HACKERS] Block level parallel vacuum