From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: eve.fritz@qonto.com
Subject: 28.4.4. Progress Reporting phase status
Date: Thu, 30 May 2024 15:50:49 +0000
Message-ID: <171708424943.2021730.15027954353131825880@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/progress-reporting.html
Description:
Hi there,
I noticed that in "28.4.4. Progress Reporting" chapter for
`pg_stat_progress_create_index`, the "Table 28.43. CREATE INDEX Phases" may
be misleading as phase displayed for "building index" is often more
detailed.
I found in this presentation[1] (slide 20) what seems to be the exact status
displayed by the table while creating the index.
Maybe documentation table displaying all status could be extended to display
the following status:
- building index: initializing [2]
- building index: scanning table
- building index: sorting live tuples
- building index: sorting dead tuples
- building index: loading tuples in tree
I hope this email is somewhat useful and I apologise in advance as english
is my second language.
Best regards from France,
Eve Fritz
[1] https://wiki.postgresql.org/images/3/38/Progress-report.pdf
[2] I'm not sure that this one actually exists but I've seen the ones below
while testing in my local environment
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, eve.fritz@qonto.com
Subject: Re: 28.4.4. Progress Reporting phase status
In-Reply-To: <171708424943.2021730.15027954353131825880@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox