Could not use index because of indcheckxmin is true

From: Japin Li <japinli(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Could not use index because of indcheckxmin is true
Date: 2023-10-12 07:06:17
Message-ID: MEYP282MB16694E0A76DD574FE7A31BC8B6D3A@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2023-10-12 14:30:02 Re: Could not use index because of indcheckxmin is true
Previous Message Rob Sargent 2023-10-03 03:14:16 Re: A situation with one parent table and 3 child tables