Re: "as quickly as possible" (was: remove spurious CREATE INDEX CONCURRENTLY wait)

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

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

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: Michael Paquier <michael@paquier.xyz>, Andres Freund <andres@anarazel.de>, Dmitry Dolgov <9erthalion6@gmail.com>, James Coleman <jtc331@gmail.com>, Pg Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2020-11-23T22:38:54Z

Lists: pgsql-hackers

Attachments

interesting-msg.patch (text/x-diff) patch

On 2020-Nov-23, Tom Lane wrote:

> Here's a draft patch.

Here's another of my own.  Outside of elog.c it seems identical.

Commits

Restore lock level to set vacuum flags
- 9aa91cb33b70 14.2 landed
- 0726c764bc4e 15.0 landed
Restore lock level to update statusFlags
- dcfff74fb166 14.0 landed
Avoid spurious waits in concurrent indexing
- c98763bf51bf 14.0 landed
Centralize logic for skipping useless ereport/elog calls.
- 789b938bf2b8 14.0 landed
Don't hold ProcArrayLock longer than needed in rare cases
- 450c8230b1f7 14.0 landed
Relax lock level for setting PGPROC->statusFlags
- 27838981be9d 14.0 landed
Rename PGPROC->vacuumFlags to statusFlags
- cd9c1b3e197a 14.0 landed
snapshot scalability: Move PGXACT->vacuumFlags to ProcGlobal->vacuumFlags.
- 5788e258bb26 14.0 cited
Allow an autovacuum worker to be interrupted automatically when it is found
- acac68b2bcae 8.3.0 cited