Could not use index because of indcheckxmin is true - Mailing list pgsql-sql

Hi,

When I create an index using CREATE INDEX (without concurrently), I get
an index which indcheckxmin is true.  According to the docs[1], it cannot
be used with indcheckxmin is ture, how can I fix this?

> indcheckxmin bool
>     If true, queries must not use the index until the xmin of this pg_index
>     row is below their TransactionXmin event horizon, because the table may
>     contain broken HOT chains with incompatible rows that they can see

[1] https://www.postgresql.org/docs/current/catalog-pg-index.html

-- 
Regrads,
Japin Li