Re: {CREATE INDEX, REINDEX} CONCURRENTLY improvements

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

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

To: Matthias van de Meent <boekewurm+postgres@gmail.com>

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

Date: 2021-02-23T00:15:31Z

Lists: pgsql-hackers

Attachments

v3-0001-Teach-VACUUM-to-ignore-CIC.patch (text/x-diff)

On 2021-Feb-22, Álvaro Herrera wrote:

> Here's an updated patch.
> 
> I haven't added commentary or documentation to account for the new
> assumption, per Matthias' comment and Robert's discussion thereof.

Done that.  I also restructured the code a bit, since one line in
ComputedXidHorizons was duplicative.


-- 
Álvaro Herrera                            39°49'30"S 73°17'W
Tom: There seems to be something broken here.
Teodor: I'm in sackcloth and ashes...  Fixed.
        http://archives.postgresql.org/message-id/482D1632.8010507@sigaev.ru

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