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:horikyota....@gmail.com] Sent: Monday, October 28, 2019 2:27 PM To: Shinoda, Noriyoshi (PN Japan A&PS Delivery) <noriyoshi.shin...@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.shin...@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 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
