Re: Improving connection scalability: GetSnapshotData()

From: Andres Freund <andres(at)anarazel(dot)de>
To: Daniel Gustafsson <daniel(at)yesql(dot)se>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Peter Geoghegan <pg(at)bowt(dot)ie>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>
Subject: Re: Improving connection scalability: GetSnapshotData()
Date: 2020-07-16 01:25:32
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


On 2020-07-01 14:42:59 +0200, Daniel Gustafsson wrote:
> This patch no longer applies to HEAD, please submit a rebased version. I've
> marked it Waiting on Author in the meantime.


Here's a rebased version. There's a good bit of commit message
polishing and some code and comment cleanup compared to the last
version. Oh, and obviously the conflicts are resolved.

It could make sense to split the conversion of
VariableCacheData->latestCompletedXid to FullTransactionId out from 0001
into is own commit. Not sure...

I've played with splitting 0003, to have the "infrastructure" pieces
separate, but I think it's not worth it. Without a user the changes look
weird and it's hard to have the comment make sense.


Andres Freund

Attachment Content-Type Size
v11-0001-snapshot-scalability-Don-t-compute-global-horizo.patch text/x-diff 135.5 KB
v11-0002-snapshot-scalability-Move-PGXACT-xmin-back-to-PG.patch text/x-diff 20.3 KB
v11-0003-snapshot-scalability-Introduce-dense-array-of-in.patch text/x-diff 50.3 KB
v11-0004-snapshot-scalability-Move-PGXACT-vacuumFlags-to-.patch text/x-diff 18.9 KB
v11-0005-snapshot-scalability-Move-subxact-info-to-ProcGl.patch text/x-diff 26.2 KB
v11-0006-snapshot-scalability-cache-snapshots-using-a-xac.patch text/x-diff 11.1 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2020-07-16 01:33:06 Re: Improving connection scalability: GetSnapshotData()
Previous Message Kyotaro Horiguchi 2020-07-16 00:30:12 "cert" + clientcert=verify-ca in pg_hba.conf?