OFFSET optimisation for IndexScan using visibility map

Title

Topic

Performance

Created

2018-02-07 08:21:14

Last modified

2018-10-02 04:35:53 (5 years, 11 months ago)

Latest email

2018-10-02 04:35:45 (5 years, 11 months 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

Git

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