Re: {CREATE INDEX, REINDEX} CONCURRENTLY improvements

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread View on postgr.es

From: Álvaro Herrera <alvherre@alvh.no-ip.org>

To: Masahiko Sawada <sawada.mshk@gmail.com>

Cc: Hamid Akhtar <hamid.akhtar@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2021-01-15T14:29:26Z

Lists: pgsql-hackers

Attachments

vacuum-cic.patch (text/x-diff) patch

So one last remaining improvement was to have VACUUM ignore processes
doing CIC and RC to compute the Xid horizon of tuples to remove.  I
think we can do something simple like the attached patch.

-- 
Álvaro Herrera       Valdivia, Chile
"Aprender sin pensar es inútil; pensar sin aprender, peligroso" (Confucio)

Commits

VACUUM: ignore indexing operations with CONCURRENTLY
- d9d076222f5b 14.0 landed
Avoid spurious wait in concurrent reindex
- f9900df5f949 14.0 landed
Invent struct ReindexIndexInfo
- c6c4b37395b2 14.0 landed