Re: pgstatindex vs. !indisready

Noah Misch <noah(at)leadboat(dot)com> writes:
> Running pgstatindex on some !indisready indexes fails with "ERROR: XX001:
> could not read block 0 in file". This reproduces it:
> ...
> Since XX001 = ERRCODE_DATA_CORRUPTED appears in the "can't-happen" class, it's
> not a good fit for this scenario. I propose to have pgstatindex fail early on
> !indisready indexes.

+1

> We could go a step further and also fail on
> indisready&&!indisvalid indexes, which are complete enough to accept inserts
> but not complete enough to answer queries. I don't see a reason to do that,
> but maybe someone else will.

Hmm. Seems like the numbers pgstatindex would produce for a
not-yet-complete index would be rather irrelevant, even if the case
doesn't risk any outright problems. I'd be inclined to be
conservative and insist on indisvalid being true too.

regards, tom lane