How to detect corrupted indexes in PostgreSQL?
When I pull data from a column with primary key attribute in a table with where condition, it brings incomplete results. Likewise, when I sort with order by in the relevant column, the data is missing. When you dump the table and press it to another database or transfer the table to another table by changing its name, the data comes back healthy. In this case I suspect the primary key is corrupt. What do I need to do to scan the whole database for corrupt primary keys.
