Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k7tGU-0003YY-7m for pgsql-committers@arkaria.postgresql.org; Tue, 18 Aug 2020 04:30:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k7tGS-0004z9-GW for pgsql-committers@arkaria.postgresql.org; Tue, 18 Aug 2020 04:30:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k7tGS-0004z1-Ao for pgsql-committers@lists.postgresql.org; Tue, 18 Aug 2020 04:30:24 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k7tGP-0005Te-LQ for pgsql-committers@lists.postgresql.org; Tue, 18 Aug 2020 04:30:23 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k7tGP-0005bP-Cb for pgsql-committers@lists.postgresql.org; Tue, 18 Aug 2020 04:30:21 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k7tGP-0005V0-5k for pgsql-committers@lists.postgresql.org; Tue, 18 Aug 2020 04:30:21 +0000 Content-Type: multipart/mixed; boundary="===============7245753035815636393==" MIME-Version: 1.0 From: Andres Freund To: pgsql-committers@lists.postgresql.org Subject: pgsql: snapshot scalability: cache snapshots using a xact completion co X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 18 Aug 2020 04:30:21 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7245753035815636393== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 c25hcHNob3Qgc2NhbGFiaWxpdHk6IGNhY2hlIHNuYXBzaG90cyB1c2luZyBhIHhhY3QgY29tcGxl dGlvbiBjb3VudGVyLgoKUHJldmlvdXMgY29tbWl0cyBtYWRlIGl0IGZhc3Rlci9tb3JlIHNjYWxh YmxlIHRvIGNvbXB1dGUgc25hcHNob3RzLiBCdXQgbm90CmJ1aWxkaW5nIGEgc25hcHNob3QgaXMg c3RpbGwgZmFzdGVyLiBOb3cgdGhhdCBHZXRTbmFwc2hvdERhdGEoKSBkb2VzIG5vdAptYWludGFp biBSZWNlbnRHbG9iYWwqIGFueW1vcmUsIHRoYXQgaXMgYWN0dWFsbHkgbm90IHRvbyBoYXJkOgoK VGhpcyBjb21taXQgaW50cm9kdWNlcyB4YWN0Q29tcGxldGlvbkNvdW50LCB3aGljaCB0cmFja3Mg dGhlIG51bWJlciBvZgp0b3AtbGV2ZWwgdHJhbnNhY3Rpb25zIHdpdGggeGlkcyAoaS5lLiB3aGlj aCBtYXkgaGF2ZSBtb2RpZmllZCB0aGUgZGF0YWJhc2UpCnRoYXQgY29tcGxldGVkIGluIHNvbWUg Zm9ybSBzaW5jZSB0aGUgc3RhcnQgb2YgdGhlIHNlcnZlci4KCldlIGNhbiBhdm9pZCByZWJ1aWxk aW5nIHRoZSBzbmFwc2hvdCdzIGNvbnRlbnRzIHdoZW5ldmVyIHRoZSBjdXJyZW50CnhhY3RDb21w bGV0aW9uQ291bnQgaXMgdGhlIHNhbWUgYXMgaXQgd2FzIHdoZW4gdGhlIHNuYXBzaG90IHdhcwpv cmlnaW5hbGx5IGJ1aWx0LiAgQ3VycmVudGx5IHRoaXMgY2hlY2sgaGFwcGVucyB3aGlsZSBob2xk aW5nClByb2NBcnJheUxvY2suIFdoaWxlIGl0J3MgbGlrZWx5IHBvc3NpYmxlIHRvIHBlcmZvcm0g dGhlIGNoZWNrIHdpdGhvdXQKYWNxdWlyaW5nIFByb2NBcnJheUxvY2ssIGl0IHNlZW1zIGJldHRl ciB0byBkbyB0aGF0IHNlcGFyYXRlbHkgLwpsYXRlciwgc29tZSBjYXJlZnVsIGFuYWx5c2lzIGlz IHJlcXVpcmVkLiBFdmVuIHdpdGggdGhlIGxvY2sgdGhpcyBpcyBhCnNpZ25pZmljYW50IHdpbiBv biBpdHMgb3duLgoKT24gYSBzbWFsbGVyIHR3byBzb2NrZXQgbWFjaGluZSB0aGlzIGdhaW5zIGFu b3RoZXIgfjEuMDN4LCBvbiBhIGxhcmdlcgptYWNoaW5lIHRoZSBlZmZlY3QgaXMgcm91Z2hseSBk b3VibGUgKGVhcmxpZXIgcGF0Y2ggdmVyc2lvbiB0ZXN0ZWQKdGhvdWdoKS4gIElmIHdlIHdlcmUg YWJsZSB0byBzYWZlbHkgYXZvaWQgdGhlIGxvY2sgdGhlcmUnZCBiZSBhbm90aGVyCnNpZ25pZmlj YW50IGdhaW4gb24gdG9wIG9mIHRoYXQuCgpBdXRob3I6IEFuZHJlcyBGcmV1bmQgPGFuZHJlc0Bh bmFyYXplbC5kZT4KUmV2aWV3ZWQtQnk6IFJvYmVydCBIYWFzIDxyb2JlcnRtaGFhc0BnbWFpbC5j b20+ClJldmlld2VkLUJ5OiBUaG9tYXMgTXVucm8gPHRob21hcy5tdW5yb0BnbWFpbC5jb20+ClJl dmlld2VkLUJ5OiBEYXZpZCBSb3dsZXkgPGRncm93bGV5bWxAZ21haWwuY29tPgpEaXNjdXNzaW9u OiBodHRwczovL3Bvc3Rnci5lcy9tLzIwMjAwMzAxMDgzNjAxLmV3czZoejVkZHVjM3cyc2VAYWxh cDMuYW5hcmF6ZWwuZGUKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0 cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi82MjNhOWJhNzliYmRkMTFjNWVj Y2IzMGI4YmQ1YzQ0NjEzMGU1MjFjCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMv YmFja2VuZC9yZXBsaWNhdGlvbi9sb2dpY2FsL3NuYXBidWlsZC5jIHwgICAxICsKc3JjL2JhY2tl bmQvc3RvcmFnZS9pcGMvcHJvY2FycmF5LmMgICAgICAgICB8IDEyNSArKysrKysrKysrKysrKysr KysrKysrKy0tLS0tCnNyYy9iYWNrZW5kL3V0aWxzL3RpbWUvc25hcG1nci5jICAgICAgICAgICAg fCAgIDQgKwpzcmMvaW5jbHVkZS9hY2Nlc3MvdHJhbnNhbS5oICAgICAgICAgICAgICAgIHwgICA5 ICsrCnNyYy9pbmNsdWRlL3V0aWxzL3NuYXBzaG90LmggICAgICAgICAgICAgICAgfCAgIDcgKysK NSBmaWxlcyBjaGFuZ2VkLCAxMjYgaW5zZXJ0aW9ucygrKSwgMjAgZGVsZXRpb25zKC0pCgo= --===============7245753035815636393==--