public inbox for [email protected]  

help / color / mirror / Atom feed

From: PG Doc comments form <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: INVALID index while concurrent indexing in progress?
Date: Wed, 18 May 2022 19:33:04 +0000
Message-ID: <[email protected]> (raw)

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.

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: INVALID index while concurrent indexing in progress?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox