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

ID 1135

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

Topic Performance

Created 2017-05-12 16:00:56

Last modified 2017-09-07 23:42:10 (7 years, 2 months ago)

Latest email 2017-09-07 23:43:11 (7 years, 2 months ago)

Status

2017-09: Committed

Target version

Authors Dmitriy Sarafannikov (dsarafan)

Reviewers Andrey Borodin (x4m)Become reviewer

Committer Tom Lane (tgl)

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/1135
git checkout commitfest/cf/1135

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