Improving connection scalability: GetSnapshotData()

Edit

ID 2500

Title Improving connection scalability: GetSnapshotData()

Topic Performance

Created 2020-03-01 08:38:02

Last modified 2020-09-04 17:35:03 (4 years, 2 months ago)

Latest email 2020-09-30 22:43:17 (4 years, 1 month 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 CFbot results (CirrusCI) CFbot GitHub Git

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

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

Edit