Re:

Peter, thank you for you response.

bt_index_check() shows this:

ERROR: item order invariant violated for index "vocabulary_phrase_key"
DETAIL: Lower index tid=(29915,116) (points to index tid=(97262,1)) higher
index tid=(29915,117) (points to index tid=(118496,1)) page
lsn=5A8/6AA20EC8.
SQL state: XX002

--
Vladimir

вт, 24 сент. 2019 г. в 14:04, Peter Geoghegan <pg(at)bowt(dot)ie>:
>
> On Tue, Sep 24, 2019 at 1:55 PM Vladimir Ryabtsev <greatvovan(at)gmail(dot)com>
wrote:
> I would try running contrib/amcheck, which should be able to confirm
> index corruption, and give you a specific complaint. You may then be
> able to inspect the exact index page with the problem using
> contrib/pageinspect. Something like this ought to do it on Postgres
> 10:
>
> CREATE EXTENSION IF NOT EXISTS amcheck
> SELECT bt_index_check('vocabulary_phrase_key');
>