Re: INVALID index while concurrent indexing in progress?
От
Rajakavitha Kodhandapani
Тема
Re: INVALID index while concurrent indexing in progress?
Дата
Msg-id
CABx-2BAo+bUGWJqrC-eN0yRppcGDOY9xvm_-6Y9UjNjSrE=o_Q@mail.gmail.com
Ответ на
INVALID index while concurrent indexing in progress? (PG Doc comments form)
Список
Дерево обсуждения
INVALID index while concurrent indexing in progress? PG Doc comments form <noreply@postgresql.org>
Re: INVALID index while concurrent indexing in progress? Rajakavitha Kodhandapani <krajakavitha@gmail.com>
Re: INVALID index while concurrent indexing in progress? Laurenz Albe <laurenz.albe@cybertec.at>
Re: INVALID index while concurrent indexing in progress? Lauren Fliksteen <dancernerd32@gmail.com>
Re: INVALID index while concurrent indexing in progress? Rajakavitha Kodhandapani <krajakavitha@gmail.com>
Re: INVALID index while concurrent indexing in progress? Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: INVALID index while concurrent indexing in progress? Rajakavitha Kodhandapani <krajakavitha@gmail.com>
Re: INVALID index while concurrent indexing in progress? Laurenz Albe <laurenz.albe@cybertec.at>
Re: INVALID index while concurrent indexing in progress? Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: INVALID index while concurrent indexing in progress? Laurenz Albe <laurenz.albe@cybertec.at>
Re: INVALID index while concurrent indexing in progress? Rajakavitha Kodhandapani <krajakavitha@gmail.com>
Hi,
This is my first attempt at contributing to the documentation of PostgreSQL.
Here's the patch. Please let me know if any other changes need to be made.
Regards,
Rajie
On Thu, May 19, 2022 at 1:10 AM PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/sql-createindex.html
Description:
I think the INVALID index can use further explanation, in particular, from
my experience it seems like when building an index concurrently, the index
gets inserted and labeled invalid while the index is being built, and then
the label gets removed if it finishes successfully or gets left on the index
if there is a failure while building the index. It is my current
understanding, after experimenting, that INVALID means 'incomplete', whether
that's because it's in progress or because it was unable to be completed,
but prior to my experiment my understanding was that INVALID indicated
failure.
This was especially confusing when we were adding an index to a very large
table because we assumed the INVALID index indicated failure when we
couldn't find any other sign of progress or failure.
В списке pgsql-docs по дате отправления
От: PG Doc comments form
Дата: