Improving connection scalability: GetSnapshotData()

Title

Topic

Performance

Created

2020-03-01 08:38:02

Last modified

2020-09-04 17:35:03 (4 years ago)

Latest email

2020-09-30 22:43:17 (3 years, 11 months ago)

Status

2020-09: Committed

2020-07: Moved to next CF

2020-03: Moved to next CF

Target version

Authors

Andres Freund (andresfreund)

Reviewers

Become reviewer

Committer

Andres Freund (andresfreund)

Links

Git

Emails

Improving connection scalability: GetSnapshotData(): First at 2020-03-01 08:36:01 by Andres Freund <andres at anarazel.de>
Latest at 2020-09-30 22:43:17 by Andres Freund <andres at anarazel.de>
Latest attachment (v3-0001-Fix-and-test-snapshot-behaviour-on-standby.patch) at 2020-09-30 22:43:17 from Andres Freund <andres at anarazel.de>
    Attachment (v3-0001-Fix-and-test-snapshot-behaviour-on-standby.patch) at 2020-09-30 22:43:17 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v2-0001-WIP-fix-and-test-snapshot-behaviour-on-standby.patch) at 2020-09-14 23:17:18 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (snapshot-cache-standby-fix.v1.patch) at 2020-09-09 08:02:58 from Ian Barwick <ian.barwick at 2ndquadrant.com> (Patch: Yes)
    Attachment (standby-row-visibility-test.v1.patch) at 2020-09-09 06:28:07 from Ian Barwick <ian.barwick at 2ndquadrant.com> (Patch: Yes)
    Attachment (pgbench.svg) at 2020-09-07 14:20:53 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: No)
    Attachment (performance-impact-of-idle-connections-1active-prepost.png) at 2020-09-04 19:11:31 from Andres Freund <andres at anarazel.de> (Patch: No)
    Attachment (add-delay-before-vacuum.patch) at 2020-08-16 20:17:23 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v13-0001-snapshot-scalability-Don-t-compute-global-horizo.patch) at 2020-08-12 17:38:55 from Andres Freund <andres at anarazel.de> (Patch: No)
    Attachment (v12-0001-Track-latest-completed-xid-as-a-FullTransactionI.patch) at 2020-07-24 01:11:43 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v11-0001-snapshot-scalability-Don-t-compute-global-horizo.patch) at 2020-07-16 01:25:32 from Andres Freund <andres at anarazel.de> (Patch: No)
    Attachment (v9-0001-snapshot-scalability-Don-t-compute-global-horizon.patch) at 2020-04-08 12:43:18 from Andres Freund <andres at anarazel.de> (Patch: No)
    Attachment (v7-0012-WIP-pgbench.patch) at 2020-04-07 12:18:51 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v1-0001-TMP-work-around-missing-snapshot-registrations.patch) at 2020-04-07 12:15:03 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (excluding_connections_est_3990x.png) at 2020-04-05 12:05:12 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (connection-scalability-improvements-2.png) at 2020-03-02 23:24:21 from Andres Freund <andres at anarazel.de> (Patch: No)
    Attachment (connection-scalability-improvements.png) at 2020-03-01 08:46:38 from Andres Freund <andres at anarazel.de> (Patch: No)
    Attachment (v1-0001-WIP-Ensure-snapshot-is-registered-within-ScanPgRe.patch.gz) at 2020-03-01 08:36:01 from Andres Freund <andres at anarazel.de> (Patch: No)

History

When	Who	What
2020-09-04 17:35:03	Andres Freund (andresfreund)	Closed in commitfest 2020-09 with status: Committed
2020-09-04 17:35:03	Andres Freund (andresfreund)	Changed committer to andresfreund
2020-07-31 19:43:45	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2020-07 with status: Moved to next CF
2020-07-31 19:43:37	Daniel Gustafsson (d_gustafsson)	New status: Needs review
2020-07-01 12:43:07	Daniel Gustafsson (d_gustafsson)	New status: Waiting on Author
2020-04-08 15:32:44	David Steele (dsteele)	Closed in commitfest 2020-03 with status: Moved to next CF
2020-03-01 08:38:22	Andres Freund (andresfreund)	Changed authors to Andres Freund (andresfreund)
2020-03-01 08:38:22	Andres Freund (andresfreund)	Changed gitlink to https://github.com/anarazel/postgres/tree/pgxact-split
2020-03-01 08:38:02	Andres Freund (andresfreund)	Attached mail thread 20200301083601.ews6hz5dduc3w2se@alap3.anarazel.de
2020-03-01 08:38:02	Andres Freund (andresfreund)	Created patch record