MIME-Version: 1.0
References: <165290238488.670.7500177735573254738@wrigleys.postgresql.org>
In-Reply-To: <165290238488.670.7500177735573254738@wrigleys.postgresql.org>
From: Rajakavitha Kodhandapani <krajakavitha@gmail.com>
Date: Thu, 19 May 2022 19:02:41 +0530
Message-ID: 
 <CABx-2BAo+bUGWJqrC-eN0yRppcGDOY9xvm_-6Y9UjNjSrE=o_Q@mail.gmail.com>
Subject: Re: INVALID index while concurrent indexing in progress?
To: dancernerd32@gmail.com, pgsql-docs@lists.postgresql.org
Content-Type: multipart/mixed; boundary="00000000000029bccd05df5d694f"
Archived-At: 
 <https://www.postgresql.org/message-id/CABx-2BAo%2BbUGWJqrC-eN0yRppcGDOY9xvm_-6Y9UjNjSrE%3Do_Q%40mail.gmail.com>
Precedence: bulk

--00000000000029bccd05df5d694f
Content-Type: multipart/alternative; boundary="00000000000029bccb05df5d694d"

--00000000000029bccb05df5d694d
Content-Type: text/plain; charset="UTF-8"

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.
>

--00000000000029bccb05df5d694d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div>This is my first attempt at contrib=
uting to the documentation of PostgreSQL.</div><div>Here&#39;s the patch. P=
lease let me know if any other changes need to be made.</div><div><br></div=
><div>Regards,</div><div>Rajie</div></div><br><div class=3D"gmail_quote"><d=
iv dir=3D"ltr" class=3D"gmail_attr">On Thu, May 19, 2022 at 1:10 AM PG Doc =
comments form &lt;<a href=3D"mailto:noreply@postgresql.org">noreply@postgre=
sql.org</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"=
margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-lef=
t:1ex">The following documentation comment has been logged on the website:<=
br>
<br>
Page: <a href=3D"https://www.postgresql.org/docs/14/sql-createindex.html" r=
el=3D"noreferrer" target=3D"_blank">https://www.postgresql.org/docs/14/sql-=
createindex.html</a><br>
Description:<br>
<br>
I think the INVALID index can use further explanation, in particular, from<=
br>
my experience it seems like when building an index concurrently, the index<=
br>
gets inserted and labeled invalid while the index is being built, and then<=
br>
the label gets removed if it finishes successfully or gets left on the inde=
x<br>
if there is a failure while building the index.=C2=A0 It is my current<br>
understanding, after experimenting, that INVALID means &#39;incomplete&#39;=
, whether<br>
that&#39;s because it&#39;s in progress or because it was unable to be comp=
leted,<br>
but prior to my experiment my understanding was that INVALID indicated<br>
failure.<br>
<br>
This was especially confusing when we were adding an index to a very large<=
br>
table because we assumed the INVALID index indicated failure when we<br>
couldn&#39;t find any other sign of progress or failure.<br>
</blockquote></div>

--00000000000029bccb05df5d694d--

--00000000000029bccd05df5d694f
Content-Type: text/rtf; charset="US-ASCII"; name="update-invalid.patch.rtf"
Content-Disposition: attachment; filename="update-invalid.patch.rtf"
Content-Transfer-Encoding: base64
Content-ID: <f_l3d1yfy30>
X-Attachment-Id: f_l3d1yfy30

e1xydGYxXGFuc2lcYW5zaWNwZzEyNTJcY29jb2FydGYyNjM2Clxjb2NvYXRleHRzY2FsaW5nMFxj
b2NvYXBsYXRmb3JtMHtcZm9udHRibFxmMFxmbmlsXGZjaGFyc2V0MCBNZW5sby1SZWd1bGFyO1xm
MVxmbmlsXGZjaGFyc2V0MCBNZW5sby1Cb2xkO30Ke1xjb2xvcnRibDtccmVkMjU1XGdyZWVuMjU1
XGJsdWUyNTU7XHJlZDE1OVxncmVlbjE2MFxibHVlMjg7XHJlZDQ2XGdyZWVuMTc0XGJsdWUxODc7
XHJlZDQ3XGdyZWVuMTgwXGJsdWUyOTsKXHJlZDBcZ3JlZW4wXGJsdWUwO1xyZWQxODBcZ3JlZW4z
NlxibHVlMjU7fQp7XCpcZXhwYW5kZWRjb2xvcnRibDs7XGNzc3JnYlxjNjg0NjlcYzY4MDEyXGMx
NDIxMTtcY3NzcmdiXGMyMDE5OVxjNzMyNDFcYzc4MjUxO1xjc3NyZ2JcYzIwMjQxXGM3Mzg5OFxj
MTQ5NTA7Clxjc2dyYXlcYzA7XGNzc3JnYlxjNzY0MTFcYzIxNjk3XGMxMjUyNzt9ClxwYXBlcncx
MTkwMFxwYXBlcmgxNjg0MFxtYXJnbDE0NDBcbWFyZ3IxNDQwXHZpZXd3MTYzMDBcdmlld2g4NDAw
XHZpZXdraW5kMApccGFyZFx0eDU2MFx0eDExMjBcdHgxNjgwXHR4MjI0MFx0eDI4MDBcdHgzMzYw
XHR4MzkyMFx0eDQ0ODBcdHg1MDQwXHR4NTYwMFx0eDYxNjBcdHg2NzIwXHBhcmRpcm5hdHVyYWxc
cGFydGlnaHRlbmZhY3RvcjAKClxmMFxmczIyIFxjZjIgXENvY29hTGlnYXR1cmUwIGNvbW1pdCAw
OTI5NjExZjExYTNkMzI2MzgzMjA0MzM3MzU5ZWZlZjFjZmVkOTY0ICgKXGYxXGIgXGNmMyBIRUFE
IC0+IFxjZjQgdXBkYXRlLWluZGV4ClxmMFxiMCBcY2YyIClcY2Y1IFwKQXV0aG9yOiBSYWpha2F2
aXRoYTEgPGtyYWpha2F2aXRoYUBnbWFpbC5jb20+XApEYXRlOiAgIFRodSBNYXkgMTkgMTg6MzM6
MDQgMjAyMiArMDUzMFwKXHBhcmRcdHg1NjBcdHgxMTIwXHR4MTY4MFx0eDIyNDBcdHgyODAwXHR4
MzM2MFx0eDM5MjBcdHg0NDgwXHR4NTA0MFx0eDU2MDBcdHg2MTYwXHR4NjcyMFxwYXJkaXJuYXR1
cmFsXHBhcnRpZ2h0ZW5mYWN0b3IwCgpcZjFcYiBkaWZmIC0tZ2l0IGEvZG9jL3NyYy9zZ21sL3Jl
Zi9jcmVhdGVfaW5kZXguc2dtbCBiL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX2luZGV4LnNnbWwK
XGYwXGIwIFwKClxmMVxiIGluZGV4IGQzMTAyYTg3ZDkuLjcwOTAzOWMwZjggMTAwNjQ0ClxmMFxi
MCBcCgpcZjFcYiAtLS0gYS9kb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV9pbmRleC5zZ21sClxmMFxi
MCBcCgpcZjFcYiArKysgYi9kb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV9pbmRleC5zZ21sClxmMFxi
MCBcClxjZjMgQEAgLTY2NSwxMSArNjY1LDE0IEBAXGNmNSAgSW5kZXhlczpcCiAgICA8cGFyYT5c
CiAgICAgQW5vdGhlciBjYXZlYXQgd2hlbiBidWlsZGluZyBhIHVuaXF1ZSBpbmRleCBjb25jdXJy
ZW50bHkgaXMgdGhhdCB0aGVcCiAgICAgdW5pcXVlbmVzcyBjb25zdHJhaW50IGlzIGFscmVhZHkg
YmVpbmcgZW5mb3JjZWQgYWdhaW5zdCBvdGhlciB0cmFuc2FjdGlvbnNcClxjZjYgLSAgICB3aGVu
IHRoZSBzZWNvbmQgdGFibGUgc2NhbiBiZWdpbnMuICBUaGlzIG1lYW5zIHRoYXQgY29uc3RyYWlu
dCB2aW9sYXRpb25zXGNmNSBcClxjZjQgKyAgICB3aGVuIHRoZSBzZWNvbmQgdGFibGUgc2NhbiBi
ZWdpbnMuIFRoaXMgbWVhbnMgdGhhdCBjb25zdHJhaW50IHZpb2xhdGlvbnNcY2Y1IFwKICAgICBj
b3VsZCBiZSByZXBvcnRlZCBpbiBvdGhlciBxdWVyaWVzIHByaW9yIHRvIHRoZSBpbmRleCBiZWNv
bWluZyBhdmFpbGFibGVcClxjZjYgLSAgICBmb3IgdXNlLCBvciBldmVuIGluIGNhc2VzIHdoZXJl
IHRoZSBpbmRleCBidWlsZCBldmVudHVhbGx5IGZhaWxzLiAgQWxzbyxcY2Y1IFwKXGNmNiAtICAg
IGlmIGEgZmFpbHVyZSBkb2VzIG9jY3VyIGluIHRoZSBzZWNvbmQgc2NhbiwgdGhlIDxxdW90ZT5p
bnZhbGlkPC9xdW90ZT4gaW5kZXhcY2Y1IFwKXGNmNiAtICAgIGNvbnRpbnVlcyB0byBlbmZvcmNl
IGl0cyB1bmlxdWVuZXNzIGNvbnN0cmFpbnQgYWZ0ZXJ3YXJkcy5cY2Y1IFwKXGNmNCArICAgIGZv
ciB1c2UsIG9yIGV2ZW4gaW4gY2FzZXMgd2hlcmUgdGhlIGluZGV4IGJ1aWxkIGV2ZW50dWFsbHkg
ZmFpbHMuIFRoZSBpbmRleFxjZjUgXApcY2Y0ICsgICAgaXMgaW5zZXJ0ZWQgYW5kIGxhYmVsZWQg
PHF1b3RlPmludmFsaWQ8L3F1b3RlPiB3aGlsZSB0aGUgaW5kZXggaXMgYmVpbmcgYnVpbHQsXGNm
NSBcClxjZjQgKyAgICBhbmQgdGhlbiB0aGUgbGFiZWwgaXMgcmVtb3ZlZCBpZiB0aGUgaW5kZXgg
YnVpbGRzIHN1Y2Nlc3NmdWxseS4gSWYgdGhlIGluZGV4IGRvZXNcY2Y1IFwKXGNmNCArICAgIG5v
dCBidWlsZCBzdWNjZXNzZnVsbHksIHRoZW4gdGhlIGxhYmVsIDxxdW90ZT5pbnZhbGlkPC9xdW90
ZT4gcmVtYWlucy4gQWxzbywgaWYgYVxjZjUgXAp9
--00000000000029bccd05df5d694f--