Avoid full GIN index scan when possible

Edit

ID 2071

Title Avoid full GIN index scan when possible

Topic Performance

Created 2019-03-24 11:43:27

Last modified 2020-01-17 22:23:23 (4 years, 10 months ago)

Latest email 2020-01-17 22:13:33 (4 years, 10 months ago)

Status

2020-01: Committed

2019-11: Moved to next CF

2019-09: Moved to next CF

2019-07: Moved to next CF

Target version 13

Authors Julien Rouhaud (rjuju), Nikita Glukhov (n.glukhov)

Reviewers Tom Lane (tgl)Become reviewer

Committer Alexander Korotkov (smagen)

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/2071
git checkout commitfest/cf/2071

Emails

Avoid full GIN index scan when possible: First at 2019-03-24 10:52:52 by Julien Rouhaud <rjuju123 at gmail.com>
Latest at 2020-01-17 22:13:33 by Alexander Korotkov <a.korotkov at postgrespro.ru>
Latest attachment (0001-Avoid-GIN-full-scan-for-empty-ALL-keys-v15.patch) at 2020-01-17 21:33:14 from Alexander Korotkov <a.korotkov at postgrespro.ru>
    Attachment (0001-Avoid-GIN-full-scan-for-empty-ALL-keys-v15.patch) at 2020-01-17 21:33:14 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Avoid-GIN-full-scan-for-empty-ALL-keys-v14.patch) at 2020-01-14 22:47:30 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Avoid-GIN-full-scan-for-empty-ALL-keys-v13.patch) at 2020-01-14 18:43:11 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (0001-Avoid-GIN-full-scan-for-empty-ALL-keys-v12.patch) at 2020-01-14 03:03:41 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Avoid-GIN-full-scan-for-empty-ALL-keys-v11.patch) at 2020-01-11 00:10:05 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Avoid-GIN-full-scan-for-empty-ALL-keys-v10.patch) at 2020-01-08 16:31:52 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Avoid-GIN-full-scan-for-empty-ALL-keys-v09.patch) at 2019-12-25 05:25:38 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Avoid-GIN-full-scan-for-empty-ALL-keys-v08.patch) at 2019-11-22 23:35:50 from Nikita Glukhov <n.gluhov at postgrespro.ru> (Patch: Yes)
    Attachment (Avoid-GIN-full-scan-for-empty-ALL-keys-v07.patch) at 2019-08-07 20:32:20 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (0001-Avoid-GIN-full-scan-for-empty-ALL-keys-v06.patch) at 2019-08-03 01:51:16 from Nikita Glukhov <n.gluhov at postgrespro.ru> (Patch: Yes)
    Attachment (avoid_gin_fullscan-v5.patch) at 2019-08-01 18:59:00 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (avoid_gin_fullscan-v4.diff) at 2019-08-01 10:13:24 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (0001-Avoid-full-GIN-index-scan-v3.patch) at 2019-06-28 22:50:18 from Nikita Glukhov <n.gluhov at postgrespro.ru> (Patch: Yes)
    Attachment (avoid_gin_fullscan-v2.diff) at 2019-06-28 14:07:47 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (avoid_gin_fullscan-v1.diff) at 2019-03-24 10:52:52 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)

History

When	Who	What
2020-01-17 22:23:23	Tom Lane (tgl)	Closed in commitfest 2020-01 with status: Committed
2020-01-17 22:23:23	Tom Lane (tgl)	Changed committer to smagen
2020-01-17 21:47:48	Tom Lane (tgl)	New status: Ready for Committer
2019-11-25 08:08:25	Michael Paquier (michael-kun)	Closed in commitfest 2019-11 with status: Moved to next CF
2019-11-25 08:08:22	Michael Paquier (michael-kun)	New status: Needs review
2019-09-30 19:10:45	Álvaro Herrera (alvherre)	New status: Waiting on Author
2019-09-30 19:09:04	Álvaro Herrera (alvherre)	Closed in commitfest 2019-09 with status: Moved to next CF
2019-09-30 19:08:32	Álvaro Herrera (alvherre)	New status: Needs review
2019-08-01 22:15:12	Thomas Munro (macdice)	New status: Waiting on Author
2019-08-01 22:15:03	Thomas Munro (macdice)	Closed in commitfest 2019-07 with status: Moved to next CF
2019-08-01 22:14:59	Thomas Munro (macdice)	New status: Needs review
2019-08-01 18:59:16	Tom Lane (tgl)	New status: Waiting on Author
2019-08-01 10:32:39	Julien Rouhaud (rjuju)	Changed authors to Julien Rouhaud (rjuju), Nikita Glukhov (n.glukhov)
2019-08-01 10:31:50	Julien Rouhaud (rjuju)	New status: Needs review
2019-07-30 17:28:18	Tom Lane (tgl)	New status: Waiting on Author
2019-07-30 17:28:14	Tom Lane (tgl)	Added tgl as reviewer
2019-03-24 11:44:28	Julien Rouhaud (rjuju)	Changed targetversion to 13
2019-03-24 11:43:44	Julien Rouhaud (rjuju)	Changed authors to Julien Rouhaud (rjuju)
2019-03-24 11:43:27	Julien Rouhaud (rjuju)	Attached mail thread CAOBaU_YGP5-BEt5Cc0=zMve92vocPzD+XiZgiZs1kjY0cj=XBg@mail.gmail.com
2019-03-24 11:43:27	Julien Rouhaud (rjuju)	Created patch record

Edit