Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sUqIH-0064Mo-7p for pgsql-committers@arkaria.postgresql.org; Fri, 19 Jul 2024 16:17:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sUqIF-001mem-66 for pgsql-committers@arkaria.postgresql.org; Fri, 19 Jul 2024 16:17:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sUqGY-001hAk-E3 for pgsql-committers@lists.postgresql.org; Fri, 19 Jul 2024 16:15:30 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sUqGV-000Obw-7I for pgsql-committers@lists.postgresql.org; Fri, 19 Jul 2024 16:15:29 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sUqGT-0019iF-Ub for pgsql-committers@lists.postgresql.org; Fri, 19 Jul 2024 16:15:25 +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 1sUqGT-000Hl8-5h for pgsql-committers@lists.postgresql.org; Fri, 19 Jul 2024 16:15:25 +0000 Content-Type: multipart/mixed; boundary="===============6040000485685875716==" MIME-Version: 1.0 From: Melanie Plageman To: pgsql-committers@lists.postgresql.org Subject: pgsql: Ensure vacuum removes all visibly dead tuples older than OldestX X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 19 Jul 2024 16:15:25 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6040000485685875716== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RW5zdXJlIHZhY3V1bSByZW1vdmVzIGFsbCB2aXNpYmx5IGRlYWQgdHVwbGVzIG9sZGVyIHRoYW4g T2xkZXN0WG1pbgoKSWYgdmFjdXVtIGZhaWxzIHRvIHJlbW92ZSBhIHR1cGxlIHdpdGggeG1heCBv bGRlciB0aGFuClZhY3V1bUN1dG9mZnMtPk9sZGVzdFhtaW4gYW5kIHlvdW5nZXIgdGhhbiBHbG9i YWxWaXNTdGF0ZS0+bWF5YmVfbmVlZGVkLAppdCBtYXkgYXR0ZW1wdCB0byBmcmVlemUgdGhlIHR1 cGxlJ3MgeG1heCBhbmQgdGhlbiBFUlJPUiBvdXQgaW4KcHJlLWZyZWV6ZSBjaGVja3Mgd2l0aCAi Y2Fubm90IGZyZWV6ZSBjb21taXR0ZWQgeG1heCIuCgpGaXggdGhpcyBieSBoYXZpbmcgdmFjdXVt IGFsd2F5cyByZW1vdmUgdHVwbGVzIG9sZGVyIHRoYW4gT2xkZXN0WG1pbi4KCkl0IGlzIHBvc3Np YmxlIGZvciBHbG9iYWxWaXNTdGF0ZS0+bWF5YmVfbmVlZGVkIHRvIHByZWNlZGUgT2xkZXN0WG1p biBpZgptYXliZV9uZWVkZWQgaXMgZm9yY2VkIHRvIGdvIGJhY2t3YXJkIHdoaWxlIHZhY3V1bSBp cyBydW5uaW5nLiBUaGlzIGNhbgpoYXBwZW4gaWYgYSBkaXNjb25uZWN0ZWQgc3RhbmRieSB3aXRo IGEgcnVubmluZyB0cmFuc2FjdGlvbiBvbGRlciB0aGFuClZhY3V1bUN1dG9mZnMtPk9sZGVzdFht aW4gcmVjb25uZWN0cyB0byB0aGUgcHJpbWFyeSBhZnRlciB2YWN1dW0KaW5pdGlhbGx5IGNhbGN1 bGF0ZXMgR2xvYmFsVmlzU3RhdGUgYW5kIE9sZGVzdFhtaW4uCgpJbiBiYWNrIGJyYW5jaGVzIHN0 YXJ0aW5nIHdpdGggMTQsIHRoZSBmaXJzdCB2ZXJzaW9uIHVzaW5nCkdsb2JhbFZpc1N0YXRlLCBm YWlsaW5nIHRvIHJlbW92ZSB0dXBsZXMgb2xkZXIgdGhhbiBPbGRlc3RYbWluIGR1cmluZwpwcnVu aW5nIGNhdXNlZCB2YWN1dW0gdG8gaW5maW5pdGVseSBsb29wIGluIGxhenlfc2Nhbl9wcnVuZSgp LCBhcwppbnZlc3RpZ2F0ZWQgb24gdGhpcyBbMV0gdGhyZWFkLiBBZnRlciAxY2NjMWUwNWFlIHJl bW92ZWQgdGhlIHJldHJ5IGxvb3AKaW4gbGF6eV9zY2FuX3BydW5lKCkgYW5kIHN0b3BwZWQgY29t cGFyaW5nIHR1cGxlcyB0byBPbGRlc3RYbWluLCB0aGUKaGFuZyBjb3VsZCBubyBsb25nZXIgaGFw cGVuLCBidXQgd2UgY291bGQgc3RpbGwgYXR0ZW1wdCB0byBmcmVlemUgZGVhZAp0dXBsZXMgd2l0 aCB4bWF4IG9sZGVyIHRoYW4gT2xkZXN0WG1pbiAtLSByZXN1bHRpbmcgaW4gYW4gRVJST1IuCgpG aXggdGhpcyBieSBhbHdheXMgcmVtb3ZpbmcgZGVhZCB0dXBsZXMgd2l0aCB4bWF4IG9sZGVyIHRo YW4KVmFjdXVtQ3V0b2Zmcy0+T2xkZXN0WG1pbi4gVGhpcyBpcyBva2F5IGJlY2F1c2UgdGhlIHN0 YW5kYnkgd29uJ3QgcmVwbGF5CnRoZSB0dXBsZSByZW1vdmFsIHVudGlsIHRoZSB0dXBsZSBpcyBy ZW1vdmFibGUuIFRodXMsIHRoZSB3b3JzdCB0aGF0IGNhbgpoYXBwZW4gaXMgYSByZWNvdmVyeSBj b25mbGljdC4KClsxXSBodHRwczovL3Bvc3Rnci5lcy9tLzIwMjQwNDE1MTczOTEzLjR6eXlyd2Fm dHVqeHRoZjIlNDBhd29yazMuYW5hcmF6ZWwuZGUjMWIyMTZiNzc2OGI1YmQ1NzdhM2QzZDUxYmQ1 YWFkZWUKCkJhY2stcGF0Y2ggdGhyb3VnaCAxNAoKQXV0aG9yOiBNZWxhbmllIFBsYWdlbWFuClJl dmlld2VkLWJ5OiBQZXRlciBHZW9naGVnYW4sIFJvYmVydCBIYWFzLCBBbmRyZXMgRnJldW5kLCBI ZWlra2kgTGlubmFrYW5nYXMsIGFuZCBOb2FoIE1pc2NoCkRpc2N1c3Npb246IGh0dHBzOi8vcG9z dGdyLmVzL20vQ0FBS1J1X2JERDdvcTlad0IyT0pxdWI1Qm92TUc2VWpFWXNvSzJMVnR0YWRqRXF5 UkdnJTQwbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KUkVMXzE3X1NUQUJMRQoKRGV0YWls cwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvZmQ0ZjEy ZGY1ZTQ2NzkzYTY1MWYyZDBhMjcyZjg4YTZjZjRiMzU4YwoKTW9kaWZpZWQgRmlsZXMKLS0tLS0t LS0tLS0tLS0Kc3JjL2JhY2tlbmQvYWNjZXNzL2hlYXAvcHJ1bmVoZWFwLmMgIHwgMjMgKysrKysr KysrKysrKysrKysrKysrKy0Kc3JjL2JhY2tlbmQvYWNjZXNzL2hlYXAvdmFjdXVtbGF6eS5jIHwg MTQgKysrKysrKy0tLS0tLS0KMiBmaWxlcyBjaGFuZ2VkLCAyOSBpbnNlcnRpb25zKCspLCA4IGRl bGV0aW9ucygtKQoK --===============6040000485685875716==--