Re: [PROPOSAL] Use SnapshotAny in get_actual_variable_range

x4mmm@yandex-team.ru

From: Andrey Borodin <x4mmm@yandex-team.ru>
To: pgsql-hackers@postgresql.org
Cc: Dmitriy Sarafannikov <dsarafannikov@yandex.ru>
Date: 2017-08-18T08:11:40Z
Lists: pgsql-hackers
The following review has been posted through the commitfest application:
make installcheck-world:  tested, passed
Implements feature:       tested, passed
Spec compliant:           tested, passed
Documentation:            tested, passed

Oops, missed those checkboxes. Sorry for the noise. Here's correct checklist: installcheck-world passes, documented as expected. Feature is there.

Best regards, Andrey Borodin.

Commits

  1. Improve performance of get_actual_variable_range with recently-dead tuples.

  2. Use SnapshotDirty rather than an active snapshot to probe index endpoints.