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 1thvPw-008d9P-MN for pgsql-committers@arkaria.postgresql.org; Tue, 11 Feb 2025 18:55:32 +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 1thvPv-00EP5M-Dg for pgsql-committers@arkaria.postgresql.org; Tue, 11 Feb 2025 18:55:31 +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 1thvPv-00EP50-6Z for pgsql-committers@lists.postgresql.org; Tue, 11 Feb 2025 18:55:31 +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.96) (envelope-from ) id 1thvPt-000Gri-1k for pgsql-committers@lists.postgresql.org; Tue, 11 Feb 2025 18:55:30 +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 1thvPt-001yXH-0e for pgsql-committers@lists.postgresql.org; Tue, 11 Feb 2025 18:55:29 +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 1thvPs-006b6z-5H for pgsql-committers@lists.postgresql.org; Tue, 11 Feb 2025 18:55:28 +0000 Content-Type: multipart/mixed; boundary="===============7875056250858516610==" MIME-Version: 1.0 From: Melanie Plageman To: pgsql-committers@lists.postgresql.org Subject: pgsql: Eagerly scan all-visible pages to amortize aggressive vacuum X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 11 Feb 2025 18:55:28 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7875056250858516610== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RWFnZXJseSBzY2FuIGFsbC12aXNpYmxlIHBhZ2VzIHRvIGFtb3J0aXplIGFnZ3Jlc3NpdmUgdmFj dXVtCgpBZ2dyZXNzaXZlIHZhY3V1bXMgbXVzdCBzY2FuIGV2ZXJ5IHVuZnJvemVuIHR1cGxlIGlu IG9yZGVyIHRvIGFkdmFuY2UKdGhlIHJlbGZyb3plbnhpZC9yZWxtaW5teGlkLiBCZWNhdXNlIGRh dGEgaXMgb2Z0ZW4gdmFjdXVtZWQgYmVmb3JlIGl0IGlzCm9sZCBlbm91Z2ggdG8gcmVxdWlyZSBm cmVlemluZywgcmVsYXRpb25zIG1heSBidWlsZCB1cCBhIGxhcmdlIGJhY2tsb2cKb2YgcGFnZXMg dGhhdCBhcmUgc2V0IGFsbC12aXNpYmxlIGJ1dCBub3QgYWxsLWZyb3plbiBpbiB0aGUgdmlzaWJp bGl0eQptYXAuIFdoZW4gYW4gYWdncmVzc2l2ZSB2YWN1dW0gaXMgdHJpZ2dlcmVkLCBhbGwgb2Yg dGhlc2UgcGFnZXMgbXVzdCBiZQpzY2FubmVkLiBUaGVzZSBwYWdlcyBoYXZlIG9mdGVuIGJlZW4g ZXZpY3RlZCBmcm9tIHNoYXJlZCBidWZmZXJzIGFuZApldmVuIGZyb20gdGhlIGtlcm5lbCBidWZm ZXIgY2FjaGUuIFRodXMsIGFnZ3Jlc3NpdmUgdmFjdXVtcyBvZnRlbiBpbmN1cgpsYXJnZSBhbW91 bnRzIG9mIGV4dHJhIEkvTyBhdCB0aGUgZXhwZW5zZSBvZiBmb3JlZ3JvdW5kIHdvcmtsb2Fkcy4K ClRvIGFtb3J0aXplIHRoZSBjb3N0IG9mIGFnZ3Jlc3NpdmUgdmFjdXVtcywgZWFnZXJseSBzY2Fu IHNvbWUKYWxsLXZpc2libGUgYnV0IG5vdCBhbGwtZnJvemVuIHBhZ2VzIGR1cmluZyBub3JtYWwg dmFjdXVtcy4KCkFsbC12aXNpYmxlIHBhZ2VzIHRoYXQgYXJlIGVhZ2VybHkgc2Nhbm5lZCBhbmQg c2V0IGFsbC1mcm96ZW4gaW4gdGhlCnZpc2liaWxpdHkgbWFwIGFyZSBjb3VudGVkIGFzIHN1Y2Nl c3NmdWwgZWFnZXIgZnJlZXplcyBhbmQgdGhvc2Ugbm90CmZyb3plbiBhcmUgY291bnRlZCBhcyBm YWlsZWQgZWFnZXIgZnJlZXplcy4KCklmIHRvbyBtYW55IGVhZ2VyIHNjYW5zIGZhaWwgaW4gYSBy b3csIGVhZ2VyIHNjYW5uaW5nIGlzIHRlbXBvcmFyaWx5CnN1c3BlbmRlZCB1bnRpbCBhIGxhdGVy IHBvcnRpb24gb2YgdGhlIHJlbGF0aW9uLiBUaGUgbnVtYmVyIG9mIGZhaWx1cmVzCnRvbGVyYXRl ZCBpcyBjb25maWd1cmFibGUgZ2xvYmFsbHkgYW5kIHBlciB0YWJsZS4KClRvIGVmZmVjdGl2ZWx5 IGFtb3J0aXplIGFnZ3Jlc3NpdmUgdmFjdXVtcywgd2UgY2FwIHRoZSBudW1iZXIgb2YKc3VjY2Vz c2VzIGFzIHdlbGwuIENhcHBpbmcgZWFnZXIgZnJlZXplIHN1Y2Nlc3NlcyBhbHNvIGxpbWl0cyB0 aGUgYW1vdW50Cm9mIHBvdGVudGlhbGx5IHdhc3RlZCB3b3JrIGlmIHRoZXNlIHBhZ2VzIGFyZSBt b2RpZmllZCBhZ2FpbiBiZWZvcmUgdGhlCm5leHQgYWdncmVzc2l2ZSB2YWN1dW0uIE9uY2Ugd2Ug cmVhY2ggdGhlIG1heGltdW0gbnVtYmVyIG9mIGJsb2NrcwpzdWNjZXNzZnVsbHkgZWFnZXIgZnJv emVuLCBlYWdlciBzY2FubmluZyBpcyBkaXNhYmxlZCBmb3IgdGhlIHJlbWFpbmRlcgpvZiB0aGUg dmFjdXVtIG9mIHRoZSByZWxhdGlvbi4KCk9yaWdpbmFsIGRlc2lnbiBpZGVhIGZyb20gUm9iZXJ0 IEhhYXMsIHdpdGggZW5oYW5jZW1lbnRzIGZyb20KQW5kcmVzIEZyZXVuZCwgVG9tYXMgVm9uZHJh LCBhbmQgbWUKClJldmlld2VkLWJ5OiBSb2JlcnQgSGFhcyA8cm9iZXJ0bWhhYXNAZ21haWwuY29t PgpSZXZpZXdlZC1ieTogTWFzYWhpa28gU2F3YWRhIDxzYXdhZGEubXNoa0BnbWFpbC5jb20+ClJl dmlld2VkLWJ5OiBBbmRyZXMgRnJldW5kIDxhbmRyZXNAYW5hcmF6ZWwuZGU+ClJldmlld2VkLWJ5 OiBSb2JlcnQgVHJlYXQgPHJvYkB4emlsbGEubmV0PgpSZXZpZXdlZC1ieTogQmlsYWwgWWF2dXog PGJ5YXZ1ejgxQGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9mbGF0 L0NBQUtSdV9aRl9LQ3padU9yUHJPcWpHVmU4aVJWV0VBSlNwek1nUlFzJTNENS12ODRjWFVnJTQw bWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0 cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8wNTIwMjZjOWI5MDMzODBiNDI4 YTRjOWJhMmVjOTA3MjZkYjgxMjg4CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpkb2Mv c3JjL3NnbWwvY29uZmlnLnNnbWwgICAgICAgICAgICAgICAgICAgICAgfCAgMzkgKysrCmRvYy9z cmMvc2dtbC9tYWludGVuYW5jZS5zZ21sICAgICAgICAgICAgICAgICB8ICAzMyArLQpkb2Mvc3Jj L3NnbWwvcmVmL2NyZWF0ZV90YWJsZS5zZ21sICAgICAgICAgICAgfCAgMTUgKwpzcmMvYmFja2Vu ZC9hY2Nlc3MvY29tbW9uL3JlbG9wdGlvbnMuYyAgICAgICAgfCAgMTQgKy0Kc3JjL2JhY2tlbmQv YWNjZXNzL2hlYXAvdmFjdXVtbGF6eS5jICAgICAgICAgIHwgNDM1ICsrKysrKysrKysrKysrKysr KysrKysrKy0tCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3ZhY3V1bS5jICAgICAgICAgICAgICAgICB8 ICAxNSArCnNyYy9iYWNrZW5kL3Bvc3RtYXN0ZXIvYXV0b3ZhY3V1bS5jICAgICAgICAgICB8ICAg NiArCnNyYy9iYWNrZW5kL3V0aWxzL21pc2MvZ3VjX3RhYmxlcy5jICAgICAgICAgICB8ICAxMCAr CnNyYy9iYWNrZW5kL3V0aWxzL21pc2MvcG9zdGdyZXNxbC5jb25mLnNhbXBsZSB8ICAgMSArCnNy Yy9iaW4vcHNxbC90YWItY29tcGxldGUuaW4uYyAgICAgICAgICAgICAgICB8ICAgMiArCnNyYy9p bmNsdWRlL2NvbW1hbmRzL3ZhY3V1bS5oICAgICAgICAgICAgICAgICB8ICAxNyArCnNyYy9pbmNs dWRlL3V0aWxzL3JlbC5oICAgICAgICAgICAgICAgICAgICAgICB8ICAgNiArCjEyIGZpbGVzIGNo YW5nZWQsIDU1MiBpbnNlcnRpb25zKCspLCA0MSBkZWxldGlvbnMoLSkKCg== --===============7875056250858516610==--