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 1oTSd8-0007CM-0N for pgsql-committers@arkaria.postgresql.org; Wed, 31 Aug 2022 18:40:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oTSc8-0005jA-LH for pgsql-committers@arkaria.postgresql.org; Wed, 31 Aug 2022 18:39:00 +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 1oTSc8-0005j0-Ee for pgsql-committers@lists.postgresql.org; Wed, 31 Aug 2022 18:39:00 +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 1oTSc1-0007uC-DK for pgsql-committers@lists.postgresql.org; Wed, 31 Aug 2022 18:38:59 +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 1oTSc0-0002QB-UA for pgsql-committers@lists.postgresql.org; Wed, 31 Aug 2022 18:38:52 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1oTSbz-000nHF-7G for pgsql-committers@lists.postgresql.org; Wed, 31 Aug 2022 18:38:51 +0000 Content-Type: multipart/mixed; boundary="===============0971121654699019229==" MIME-Version: 1.0 From: Peter Geoghegan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Derive freeze cutoff from nextXID, not OldestXmin. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 31 Aug 2022 18:38:51 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0971121654699019229== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RGVyaXZlIGZyZWV6ZSBjdXRvZmYgZnJvbSBuZXh0WElELCBub3QgT2xkZXN0WG1pbi4KCkJlZm9y ZSBub3csIHRoZSBjdXRvZmZzIHRoYXQgVkFDVVVNIHVzZWQgdG8gZGV0ZXJtaW5lIHdoaWNoIFhJ RHMvTVhJRHMKdG8gZnJlZXplIHdlcmUgZGV0ZXJtaW5lZCBhdCB0aGUgc3RhcnQgb2YgZWFjaCBW QUNVVU0gYnkgdGFraW5nIHJlbGF0ZWQKY3V0b2ZmcyB0aGF0IHJlcHJlc2VudCB3aGljaCBYSURz L01YSURzIFZBQ1VVTSBzaG91bGQgdHJlYXQgYXMgc3RpbGwKcnVubmluZywgYW5kIHN1YnRyYWN0 aW5nIGFuIFhJRC9NWElEIGFnZSBiYXNlZCB2YWx1ZSBjb250cm9sbGVkIGJ5IEdVQ3MKbGlrZSB2 YWN1dW1fZnJlZXplX21pbl9hZ2UuICBUaGUgRnJlZXplTGltaXQgY3V0b2ZmIChYSUQgZnJlZXpl IGN1dG9mZikKd2FzIGRlcml2ZWQgYnkgc3VidHJhY3RpbmcgYW4gWElEIGFnZSB2YWx1ZSBmcm9t IE9sZGVzdFhtaW4sIHdoaWxlIHRoZQpNdWx0aVhhY3RDdXRvZmYgY3V0b2ZmIChNWElEIGZyZWV6 ZSBjdXRvZmYpIHdhcyBkZXJpdmVkIGJ5IHN1YnRyYWN0aW5nCmFuIE1YSUQgYWdlIHZhbHVlIGZy b20gT2xkZXN0TXhhY3QuICBUaGlzIGFwcHJvYWNoIGRpZG4ndCBtYXRjaCB0aGUKYXBwcm9hY2gg dXNlZCBuZWFyYnkgdG8gZGV0ZXJtaW5lIHdoZXRoZXIgdGhpcyBWQUNVVU0gb3BlcmF0aW9uIHNo b3VsZApiZSBhbiBhZ2dyZXNzaXZlIFZBQ1VVTSBvciBub3QuCgpWQUNVVU0gbm93IHVzZXMgdGhl IHN0YW5kYXJkIGFwcHJvYWNoIGluc3RlYWQ6IGl0IHN1YnRyYWN0cyB0aGUgc2FtZQphZ2UtYmFz ZWQgdmFsdWVzIGZyb20gbmV4dCBYSUQvbmV4dCBNWElEIChyYXRoZXIgdGhhbiBzdWJ0cmFjdGlu ZyBmcm9tCk9sZGVzdFhtaW4vT2xkZXN0TXhhY3QpLiAgVGhpcyBhcHByb2FjaCBpcyBzaW1wbGVy IGFuZCBtb3JlIHVuaWZvcm0uCk1vc3Qgb2YgdGhlIHRpbWUgaXQgd2lsbCBoYXZlIG9ubHkgYSBu ZWdsaWdpYmxlIGltcGFjdCBvbiBob3cgYW5kIHdoZW4KVkFDVVVNIGZyZWV6ZXMuICBJdCB3aWxs IG9jY2FzaW9uYWxseSBtYWtlIFZBQ1VVTSBtb3JlIHJvYnVzdCBpbiB0aGUKZXZlbnQgb2YgcHJv YmxlbXMgY2F1c2VkIGJ5IGxvbmcgcnVubmluZyB0cmFuc2FjdGlvbi4gIFRoZXNlIGFyZSBjYXNl cwp3aGVyZSBPbGRlc3RYbWluIGFuZCBPbGRlc3RNeGFjdCBhcmUgaGVsZCBiYWNrIGJ5IHNvIG11 Y2ggdGhhdCB0aGV5CmF0dGFpbiBhbiBhZ2UgdGhhdCBpcyBhIHNpZ25pZmljYW50IGZyYWN0aW9u IG9mIHRoZSB2YWx1ZSBvZiBhZ2UtYmFzZWQKc2V0dGluZ3MgbGlrZSB2YWN1dW1fZnJlZXplX21p bl9hZ2UuCgpUaGVyZSBpcyBubyBwcmluY2lwbGVkIHJlYXNvbiB3aHkgZnJlZXppbmcgc2hvdWxk IGJlIGFmZmVjdGVkIGluIGFueSB3YXkKYnkgdGhlIHByZXNlbmNlIG9mIGEgbG9uZy1ydW5uaW5n IHRyYW5zYWN0aW9uIC0tIGF0IGxlYXN0IG5vdCBiZWZvcmUgdGhlCnBvaW50IHRoYXQgdGhlIE9s ZGVzdFhtaW4gYW5kIE9sZGVzdE14YWN0IGxpbWl0cyB1c2VkIGJ5IGVhY2ggVkFDVVVNCm9wZXJh dGlvbiBhdHRhaW4gYW4gYWdlIHRoYXQgbWFrZXMgaXQgdW5zYWZlIHRvIGZyZWV6ZSBzb21lIG9m IHRoZQpYSURzL01YSURzIHdob3NlIGFnZSBleGNlZWRzIHRoZSB2YWx1ZSBvZiB0aGUgcmVsZXZh bnQgYWdlLWJhc2VkCnNldHRpbmdzLiAgVGhlIG5ldyBhcHByb2FjaCBzaG91bGQgYXQgbGVhc3Qg bWFrZSBmcmVlemluZyBkZWdyYWRlIG1vcmUKZ3JhY2VmdWxseSB0aGFuIGJlZm9yZSwgZXZlbiBp biB0aGUgbW9zdCBleHRyZW1lIGNhc2VzLgoKQXV0aG9yOiBQZXRlciBHZW9naGVnYW4gPHBnQGJv d3QuaWU+ClJldmlld2VkLUJ5OiBOYXRoYW4gQm9zc2FydCA8bmF0aGFuZGJvc3NhcnRAZ21haWwu Y29tPgpSZXZpZXdlZC1CeTogTWF0dGhpYXMgdmFuIGRlIE1lZW50IDxib2VrZXd1cm0rcG9zdGdy ZXNAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBSDItV3prT3Y1 Q0VleU9PPWM5MVhuVDVXQlJfMGdpaTBXbjVVYlpoSj00VFR5a0RZZ0BtYWlsLmdtYWlsLmNvbQoK QnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jl c3FsLm9yZy9wZy9jb21taXRkaWZmL2MzZmZhNzMxYTVmOTljNDM2MTIwMzAxNWNlMjIxOWQyMDlm ZWE5NGMKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2FjY2Vzcy9o ZWFwL3ZhY3V1bWxhenkuYyB8ICAgMiArLQpzcmMvYmFja2VuZC9jb21tYW5kcy92YWN1dW0uYyAg ICAgICAgfCAxOTkgKysrKysrKysrKysrKysrKy0tLS0tLS0tLS0tLS0tLS0tLS0Kc3JjL2luY2x1 ZGUvY29tbWFuZHMvdmFjdXVtLmggICAgICAgIHwgICAzICstCjMgZmlsZXMgY2hhbmdlZCwgOTIg aW5zZXJ0aW9ucygrKSwgMTEyIGRlbGV0aW9ucygtKQoK --===============0971121654699019229==--