OFFSET optimisation for IndexScan using visibility map

Edit
ID 1513
Title OFFSET optimisation for IndexScan using visibility map
Topic Performance
Created 2018-02-07 08:21:14
Last modified 2018-10-02 04:35:53 (6 years ago)
Latest email 2018-10-02 04:35:45 (6 years ago)
Status
2018-09: Returned with feedback
2018-07: Moved to next CF
2018-03: Moved to next CF
Target version
Authors Michail Nikolaev (nkey)
Reviewers Heikki Linnakangas (heikki), Andrey Borodin (x4m)Become reviewer
Committer
Links CFbot results (CirrusCI) CFbot GitHub Git
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/1513
git checkout commitfest/cf/1513
Emails
[WIP PATCH] Index scan offset optimisation using visibility map
First at 2018-01-31 22:17:35 by Michail Nikolaev <michail.nikolaev at gmail.com>
Latest at 2018-10-02 04:35:45 by Michael Paquier <michael at paquier.xyz>
Latest attachment (scale-10.png) at 2018-05-21 15:43:43 from Michail Nikolaev <michail.nikolaev at gmail.com>
    Attachment (scale-10.png) at 2018-05-21 15:43:43 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: No)
    Attachment (offset_index_only_v4.patch) at 2018-03-10 14:20:01 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (offset_index_only_v3.patch) at 2018-03-06 21:03:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (offset_index_only_v2.patch) at 2018-02-13 19:04:26 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (offset_index_only.patch) at 2018-01-31 22:17:35 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
History
When Who What
2018-10-02 04:35:53 Michael Paquier (michael-kun) Closed in commitfest 2018-09 with status: Returned with feedback
2018-08-10 22:51:04 Andrew Dunstan (adunstan) New status: Waiting on Author
2018-08-10 22:37:22 Andrew Dunstan (adunstan) Closed in commitfest 2018-07 with status: Moved to next CF
2018-08-10 22:37:17 Andrew Dunstan (adunstan) New status: Needs review
2018-07-13 21:18:02 Heikki Linnakangas (heikki) New status: Waiting on Author
2018-07-13 21:17:59 Heikki Linnakangas (heikki) Added heikki as reviewer
2018-04-09 16:29:29 Andrey Borodin (x4m) Closed in commitfest 2018-03 with status: Moved to next CF
2018-04-09 16:29:15 Andrey Borodin (x4m) New status: Needs review
2018-03-12 19:55:40 Tom Lane (tgl) Removed tgl from committers
2018-03-12 19:55:35 Tom Lane (tgl) New status: Waiting on Author
2018-03-12 18:30:27 Tom Lane (tgl) Added tgl as committer
2018-03-12 12:40:50 Andrey Borodin (x4m) Posted review with messageid <152085845014.1307.17921890299725656162.pgcf@coridan.postgresql.org>
2018-03-12 12:40:50 Andrey Borodin (x4m) New status: Ready for Committer
2018-03-06 21:05:14 Michail Nikolaev (nkey) New status: Needs review
2018-03-02 05:59:11 Andrey Borodin (x4m) New status: Waiting on Author
2018-02-07 09:45:51 Michail Nikolaev (nkey) Changed gitlink to https://github.com/postgres/postgres/compare/master...michail-nikolaev:offset_index_only
2018-02-07 09:15:04 Andrey Borodin (x4m) Added x4m as reviewer
2018-02-07 08:22:55 Michail Nikolaev (nkey) Changed authors to Michail Nikolaev (nkey)
2018-02-07 08:21:15 Michail Nikolaev (nkey) Attached mail thread CANtu0oi3a1Rf1PVsBufQbm+g9ytSv75+kp7kJYvK5C1qF_0Siw@mail.gmail.com
2018-02-07 08:21:14 Michail Nikolaev (nkey) Created patch record
Edit