Re: Amcheck verification of GiST and GIN - Mailing list pgsql-hackers

From Nikolay Samokhvalov
Subject Re: Amcheck verification of GiST and GIN
Date
Msg-id CANNMO+LKbriqX5SU5HbuQ9VYqa79YLpN0sM-ErABkcki05RZwg@mail.gmail.com
Whole thread Raw
In response to Re: Amcheck verification of GiST and GIN  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: Amcheck verification of GiST and GIN
Re: Amcheck verification of GiST and GIN
List pgsql-hackers


On Thu, Feb 2, 2023 at 12:43 PM Peter Geoghegan <pg@bowt.ie> wrote:
I agree that this matters at the level of whole indexes. 

I already realized my mistake – indeed, having multiple errors for 1 index
doesn't seem to be super practically helpful. 


I think that that problem should be solved at a higher level, in the
program that runs amcheck. Note that pg_amcheck will already do this
for B-Tree indexes.

That's a great tool, and it's great it supports parallelization, very useful
on large machines.
 
We should add a "Tip" to the amcheck documentation on 14+ about this.
We should clearly advise users that they should probably just use
pg_amcheck.

and with -j$N, with high $N (unless it's production)

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Amcheck verification of GiST and GIN
Next
From: Robert Haas
Date:
Subject: Re: when the startup process doesn't (logging startup delays)