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, 8 months ago)
Latest email 2020-01-17 22:13:33 (4 years, 8 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