Fix planner performance degradation with using new type of snapshot in get_actual_variable_range

Title

Topic

Performance

Created

2017-05-12 16:00:56

Last modified

2017-09-07 23:42:10 (6 years, 8 months ago)

Latest email

2017-09-07 23:43:11 (6 years, 8 months ago)

Status

2017-09: Committed

Target version

Authors

Dmitriy Sarafannikov (dsarafan)

Reviewers

Andrey Borodin (x4m)Become reviewer

Committer

Tom Lane (tgl)

Links

Emails

[PROPOSAL] Use SnapshotAny in get_actual_variable_range: First at 2017-04-27 08:08:30 by Dmitriy Sarafannikov <dsarafannikov at yandex.ru>
Latest at 2017-09-07 23:43:11 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (snapshot_non_vacuumable_v3.patch) at 2017-05-08 14:23:47 from Dmitriy Sarafannikov <dsarafannikov at yandex.ru>
Attachment (snapshot_non_vacuumable_v3.patch) at 2017-05-08 14:23:47 from Dmitriy Sarafannikov <dsarafannikov at yandex.ru> (Patch: Yes)
Attachment (snapshot_non_vacuumable.patch) at 2017-05-04 16:12:55 from Dmitriy Sarafannikov <dsarafannikov at yandex.ru> (Patch: Yes)

History

When	Who	What
2017-09-07 23:42:10	Tom Lane (tgl)	Closed in commitfest 2017-09 with status: Committed
2017-09-07 23:35:15	Tom Lane (tgl)	Changed topic to Performance
2017-09-07 23:34:58	Tom Lane (tgl)	Added tgl as committer
2017-09-05 10:09:05	Daniel Gustafsson (d_gustafsson)	New status: Ready for Committer
2017-08-18 08:11:40	Andrey Borodin (x4m)	Posted review with messageid <20170818081140.1309.32286.pgcf@coridan.postgresql.org>
2017-08-18 06:50:39	Andrey Borodin (x4m)	Posted review with messageid <20170818065039.15349.16851.pgcf@coridan.postgresql.org>
2017-08-08 11:18:57	Andrey Borodin (x4m)	Added x4m as reviewer
2017-05-12 16:03:32	Dmitriy Sarafannikov (dsarafan)	Detached mail thread 9ADAF560-F331-4AF8-A28A-F005070C3187@yandex.ru
2017-05-12 16:02:33	Dmitriy Sarafannikov (dsarafan)	Attached mail thread 05C72CF7-B5F6-4DB9-8A09-5AC897653113@yandex.ru
2017-05-12 16:01:47	Dmitriy Sarafannikov (dsarafan)	Changed authors to Dmitriy Sarafannikov (dsarafan)
2017-05-12 16:00:56	Dmitriy Sarafannikov (dsarafan)	Attached mail thread 9ADAF560-F331-4AF8-A28A-F005070C3187@yandex.ru
2017-05-12 16:00:56	Dmitriy Sarafannikov (dsarafan)	Created patch record