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 1nb3YB-0004bz-WC for pgsql-committers@arkaria.postgresql.org; Sun, 03 Apr 2022 16:58:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nb3YA-0001QX-1l for pgsql-committers@arkaria.postgresql.org; Sun, 03 Apr 2022 16:58:02 +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 1nb3Y9-0001QO-Lb for pgsql-committers@lists.postgresql.org; Sun, 03 Apr 2022 16:58:01 +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 1nb3Y5-00031A-WE for pgsql-committers@lists.postgresql.org; Sun, 03 Apr 2022 16:57: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 1nb3Y4-0003na-Ki for pgsql-committers@lists.postgresql.org; Sun, 03 Apr 2022 16:57:56 +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 1nb3Y3-0009q6-5y for pgsql-committers@lists.postgresql.org; Sun, 03 Apr 2022 16:57:55 +0000 Content-Type: multipart/mixed; boundary="===============3569389812310544494==" MIME-Version: 1.0 From: Peter Geoghegan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Set relfrozenxid to oldest extant XID seen by VACUUM. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 03 Apr 2022 16:57:55 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3569389812310544494== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U2V0IHJlbGZyb3plbnhpZCB0byBvbGRlc3QgZXh0YW50IFhJRCBzZWVuIGJ5IFZBQ1VVTS4KCldo ZW4gVkFDVVVNIHNldCByZWxmcm96ZW54aWQgYmVmb3JlIG5vdywgaXQgc2V0IGl0IHRvIHdoYXRl dmVyIHZhbHVlIHdhcwp1c2VkIHRvIGRldGVybWluZSB3aGljaCB0dXBsZXMgdG8gZnJlZXplIC0t IHRoZSBGcmVlemVMaW1pdCBjdXRvZmYuClRoaXMgYXBwcm9hY2ggd2FzIHZlcnkgbmFpdmUuICBU aGUgcmVsZnJvemVueGlkIGludmFyaWFudCBvbmx5IHJlcXVpcmVzCnRoYXQgbmV3IHJlbGZyb3pl bnhpZCB2YWx1ZXMgYmUgPD0gdGhlIG9sZGVzdCBleHRhbnQgWElEIHJlbWFpbmluZyBpbgp0aGUg dGFibGUgKGF0IHRoZSBwb2ludCB0aGF0IHRoZSBWQUNVVU0gb3BlcmF0aW9uIGVuZHMpLCB3aGlj aCBpbgpnZW5lcmFsIG1pZ2h0IGJlIG11Y2ggbW9yZSByZWNlbnQgdGhhbiBGcmVlemVMaW1pdC4K ClZBQ1VVTSBub3cgY2FyZWZ1bGx5IHRyYWNrcyB0aGUgb2xkZXN0IHJlbWFpbmluZyBYSUQvTXVs dGlYYWN0SWQgYXMgaXQKZ29lcyAodGhlIG9sZGVzdCByZW1haW5pbmcgdmFsdWVzIF9hZnRlcl8g bGF6eV9zY2FuX3BydW5lIHByb2Nlc3NpbmcpLgpUaGUgZmluYWwgdmFsdWVzIGFyZSBzZXQgYXMg dGhlIHRhYmxlJ3MgbmV3IHJlbGZyb3plbnhpZCBhbmQgbmV3CnJlbG1pbm14aWQgaW4gcGdfY2xh c3MgYXQgdGhlIGVuZCBvZiBlYWNoIFZBQ1VVTS4gIFRoZSBvbGRlc3QgWElEIG1pZ2h0CmNvbWUg ZnJvbSBhIHR1cGxlJ3MgeG1pbiwgeG1heCwgb3IgeHZhYyBmaWVsZHMuICBJdCBtaWdodCBldmVu IGNvbWUgZnJvbQpvbmUgb2YgdGhlIHRhYmxlJ3MgcmVtYWluaW5nIE11bHRpWGFjdHMuCgpGaW5h bCByZWxmcm96ZW54aWQgdmFsdWVzIG11c3Qgc3RpbGwgYmUgPj0gRnJlZXplTGltaXQgaW4gYW4g YWdncmVzc2l2ZQpWQUNVVU0gKEZyZWV6ZUxpbWl0IHN0aWxsIGFjdHMgYXMgYSBsb3dlciBib3Vu ZCBvbiB0aGUgZmluYWwgdmFsdWUgdGhhdAphZ2dyZXNzaXZlIFZBQ1VVTSBjYW4gc2V0IHJlbGZy b3plbnhpZCB0bykuICBTaW5jZSBzdGFuZGFyZCBWQUNVVU1zCnN0aWxsIG1ha2Ugbm8gZ3VhcmFu dGVlcyBhYm91dCBhZHZhbmNpbmcgcmVsZnJvemVueGlkLCB0aGV5IG1pZ2h0IGFzCndlbGwgc2V0 IHJlbGZyb3plbnhpZCB0byBhIHZhbHVlIGZyb20gd2VsbCBiZWZvcmUgRnJlZXplTGltaXQgd2hl biB0aGUKb3Bwb3J0dW5pdHkgcHJlc2VudHMgaXRzZWxmLiAgSW4gZ2VuZXJhbCBzdGFuZGFyZCBW QUNVVU1zIG1heSBub3cgc2V0CnJlbGZyb3plbnhpZCB0byBhbnkgdmFsdWUgPiB0aGUgb3JpZ2lu YWwgcmVsZnJvemVueGlkIGFuZCA8PSBPbGRlc3RYbWluLgoKQ3JlZGl0IGZvciB0aGUgZ2VuZXJh bCBpZGVhIG9mIHVzaW5nIHRoZSBvbGRlc3QgZXh0YW50IFhJRCB0byBzZXQKcGdfY2xhc3MucmVs ZnJvemVueGlkIGF0IHRoZSBlbmQgb2YgVkFDVVVNIGdvZXMgdG8gQW5kcmVzIEZyZXVuZC4KCkF1 dGhvcjogUGV0ZXIgR2VvZ2hlZ2FuIDxwZ0Bib3d0LmllPgpSZXZpZXdlZC1CeTogQW5kcmVzIEZy ZXVuZCA8YW5kcmVzQGFuYXJhemVsLmRlPgpSZXZpZXdlZC1CeTogUm9iZXJ0IEhhYXMgPHJvYmVy dG1oYWFzQGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQUgyLVd6 a3ltRmJ6NkRfdkwram1xU25fNXExd3NGdkZyRSszN3lMZ0xfUmtmZDZHemdAbWFpbC5nbWFpbC5j b20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9z dGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8wYjAxOGZhYmFhYmE3N2UzOTUzOWNlN2ViNzFlMzRh OTBjZWIwODI1CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpkb2Mvc3JjL3NnbWwvbWFp bnRlbmFuY2Uuc2dtbCAgICAgICAgICAgICAgICAgICAgICB8ICAxNiArLQpzcmMvYmFja2VuZC9h Y2Nlc3MvaGVhcC9oZWFwYW0uYyAgICAgICAgICAgICAgICAgICB8IDMzMiArKysrKysrKysrKysr KystLS0tLS0Kc3JjL2JhY2tlbmQvYWNjZXNzL2hlYXAvdmFjdXVtbGF6eS5jICAgICAgICAgICAg ICAgfCAxNTYgKysrKysrLS0tLQpzcmMvYmFja2VuZC9jb21tYW5kcy9jbHVzdGVyLmMgICAgICAg ICAgICAgICAgICAgICB8ICAxMSArLQpzcmMvYmFja2VuZC9jb21tYW5kcy92YWN1dW0uYyAgICAg ICAgICAgICAgICAgICAgICB8ICAzOSArKy0Kc3JjL2luY2x1ZGUvYWNjZXNzL2hlYXBhbS5oICAg ICAgICAgICAgICAgICAgICAgICAgfCAgIDYgKy0Kc3JjL2luY2x1ZGUvYWNjZXNzL2hlYXBhbV94 bG9nLmggICAgICAgICAgICAgICAgICAgfCAgIDQgKy0Kc3JjL2luY2x1ZGUvY29tbWFuZHMvdmFj dXVtLmggICAgICAgICAgICAgICAgICAgICAgfCAgIDEgKwouLi4vaXNvbGF0aW9uL2V4cGVjdGVk L3ZhY3V1bS1uby1jbGVhbnVwLWxvY2sub3V0ICB8IDE4OSArKysrKysrKysrKysKc3JjL3Rlc3Qv aXNvbGF0aW9uL2V4cGVjdGVkL3ZhY3V1bS1yZWx0dXBsZXMub3V0ICAgfCAgNjcgLS0tLS0Kc3Jj L3Rlc3QvaXNvbGF0aW9uL2lzb2xhdGlvbl9zY2hlZHVsZSAgICAgICAgICAgICAgfCAgIDIgKy0K Li4uL2lzb2xhdGlvbi9zcGVjcy92YWN1dW0tbm8tY2xlYW51cC1sb2NrLnNwZWMgICAgfCAxNTAg KysrKysrKysrKwpzcmMvdGVzdC9pc29sYXRpb24vc3BlY3MvdmFjdXVtLXJlbHR1cGxlcy5zcGVj ICAgICB8ICA0OSAtLS0KMTMgZmlsZXMgY2hhbmdlZCwgNzE3IGluc2VydGlvbnMoKyksIDMwNSBk ZWxldGlvbnMoLSkKCg== --===============3569389812310544494==--