Avoid full GIN index scan when possible

Edit

2071

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Performance

Tags

Created

2019-03-24 11:43:27

Last modified

2020-01-17 22:23:23 (5 years ago)

Latest email

2020-01-17 22:13:33 (5 years ago)

Status

2020-01 (2020-01-01 - 2020-01-31): Committed

2019-11 (2019-11-01 - 2019-11-30): Moved to different CF

2019-09 (2019-09-01 - 2019-09-30): Moved to different CF

2019-07 (2019-07-01 - 2019-07-31): Moved to different CF

Target version

Authors

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

Reviewers

Tom Lane (tgl)Become reviewer

Committer

Alexander Korotkov (smagen)

Links

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