remove spurious CREATE INDEX CONCURRENTLY wait

2715

Title

Topic

Performance

Created

2020-08-31 19:46:50

Last modified

2020-11-30 19:55:04 (3 years, 11 months ago)

Latest email

2020-12-01 01:00:01 (3 years, 11 months ago)

Status

2020-11: Committed

2020-09: Moved to next CF

Target version

Authors

Álvaro Herrera (alvherre)

Reviewers

Become reviewer

Committer

Álvaro Herrera (alvherre)

Links

CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/2715
git checkout commitfest/cf/2715

Emails

remove spurious CREATE INDEX CONCURRENTLY wait: First at 2020-08-10 23:38:15 by Alvaro Herrera <alvherre at 2ndquadrant.com>
Latest at 2020-12-01 01:00:01 by Michael Paquier <michael at paquier.xyz>
Latest attachment (reindex-concurrently-2.patch) at 2020-11-27 16:53:07 from Alvaro Herrera <alvherre at alvh.no-ip.org>
    Attachment (reindex-concurrently-2.patch) at 2020-11-27 16:53:07 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (reindex-concurrently.patch) at 2020-11-26 22:48:20 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (0001-Restore-lock-level-to-update-statusFlags.patch) at 2020-11-25 20:03:58 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (interesting-msg.patch) at 2020-11-23 22:38:54 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (hide-elog-level-knowledge.patch) at 2020-11-23 22:32:35 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (0001-Don-t-hold-ProcArrayLock-longer-than-needed-in-rare-.patch) at 2020-11-23 20:31:24 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (quickly.patch) at 2020-11-18 21:41:27 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v7-0001-CREATE-INDEX-CONCURRENTLY-don-t-wait-for-its-kin.patch) at 2020-11-18 17:58:04 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v6-0001-indexcmds.c-reorder-function-prototypes.patch) at 2020-11-17 17:14:53 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v5-0001-Avoid-spurious-CREATE-INDEX-CONCURRENTLY-waits.patch) at 2020-11-17 00:23:41 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v4-0001-Rename-vaccumFlags-to-statusFlags.patch) at 2020-11-16 18:24:46 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Avoid-spurious-CREATE-INDEX-CONCURRENTLY-waits.patch) at 2020-11-09 15:47:43 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Avoid-spurious-CREATE-INDEX-CONCURRENTLY-waits.patch) at 2020-08-19 18:16:46 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-Flag-CREATE-INDEX-CONCURRENTLY-to-avoid-spurious-wai.patch) at 2020-08-10 23:38:15 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)

History

When	Who	What
2020-11-30 19:55:04	Álvaro Herrera (alvherre)	Closed in commitfest 2020-11 with status: Committed
2020-11-30 19:55:04	Álvaro Herrera (alvherre)	Changed committer to alvherre
2020-09-30 09:11:21	Michael Paquier (michael-kun)	Closed in commitfest 2020-09 with status: Moved to next CF
2020-08-31 19:46:58	Álvaro Herrera (alvherre)	Changed authors to Álvaro Herrera (alvherre)
2020-08-31 19:46:50	Álvaro Herrera (alvherre)	Attached mail thread 20200810233815.GA18970@alvherre.pgsql
2020-08-31 19:46:50	Álvaro Herrera (alvherre)	Created patch record