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_cluster function, it seems to be a phase that is executed only during sorting. Regards, Noriyoshi Shinoda -----Original Message----- From: Kyotaro Horiguchi [mailto:[email protected]] Sent: Monday, October 28, 2019 2:27 PM To: Shinoda, Noriyoshi (PN Japan A&PS Delivery) <[email protected]> Cc: [email protected] 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)" <[email protected]> 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 output in 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 "CLUSTER is" and others are "The command is".. regards. -- Kyotaro Horiguchi NTT Open Source Software Center
