On Thu, Nov 7, 2019 at 11:18 AM Asomba Djala <asombadjala8(at)gmail(dot)com> wrote:
> Thank you. What about already initialized clusters?
There is amcheck, which tests the consistency of B-Tree indexes:
https://www.postgresql.org/docs/current/amcheck.html
Recent versions have a "heapallindexed" option, too, which has the
tool test indexes against the table that they index. This is very
useful as a general purpose tool for detecting corruption.
--
Peter Geoghegan