Thank you very much.
On Thu, Nov 7, 2019, 1:31 PM Peter Geoghegan <pg@xxxxxxx> wrote:
On Thu, Nov 7, 2019 at 11:18 AM Asomba Djala <asombadjala8@xxxxxxxxx> 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