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 1nb6xf-0001uA-LI for pgsql-committers@arkaria.postgresql.org; Sun, 03 Apr 2022 20:36:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nb6xc-0001mT-QZ for pgsql-committers@arkaria.postgresql.org; Sun, 03 Apr 2022 20:36:32 +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 1nb6xc-0001mK-Jc for pgsql-committers@lists.postgresql.org; Sun, 03 Apr 2022 20:36:32 +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 1nb6xV-0004Zz-8v for pgsql-committers@lists.postgresql.org; Sun, 03 Apr 2022 20:36:31 +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 1nb6xU-00010F-QI for pgsql-committers@lists.postgresql.org; Sun, 03 Apr 2022 20:36:24 +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 1nb6xT-000BHB-4y for pgsql-committers@lists.postgresql.org; Sun, 03 Apr 2022 20:36:23 +0000 Content-Type: multipart/mixed; boundary="===============8206871953978029682==" MIME-Version: 1.0 From: Peter Geoghegan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Generalize how VACUUM skips all-frozen pages. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 03 Apr 2022 20:36:23 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8206871953978029682== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 R2VuZXJhbGl6ZSBob3cgVkFDVVVNIHNraXBzIGFsbC1mcm96ZW4gcGFnZXMuCgpOb24tYWdncmVz c2l2ZSBWQUNVVU1zIHdlcmUgYXQgYSBncmF0dWl0b3VzIGRpc2FkdmFudGFnZSAocmVsYXRpdmUg dG8KYWdncmVzc2l2ZSBWQUNVVU1zKSBhcm91bmQgYWR2YW5jaW5nIHJlbGZyb3plbnhpZCBhbmQg cmVsbWlubXhpZCBiZWZvcmUKbm93LiAgVGhlIGlzc3VlIG9ubHkgY2FtZSB1cCB3aGVuIGNvbmN1 cnJlbnQgYWN0aXZpdHkgdW5zZXQgc29tZSBoZWFwCnBhZ2UncyB2aXNpYmlsaXR5IG1hcCBiaXQg cmlnaHQgYXMgVkFDVVVNIHdhcyBjb25zaWRlcmluZyBpZiB0aGUgcGFnZQpzaG91bGQgZ2V0IGNv dW50ZWQgaW4gZnJvemVuc2tpcHBlZF9wYWdlcy4gIFRoZSBub24tYWdncmVzc2l2ZSBjYXNlCndv dWxkIHJlY2hlY2sgdGhlIGFsbC1mcm96ZW4gYml0IGF0IHRoaXMgcG9pbnQuICBUaGUgYWdncmVz c2l2ZSBjYXNlCnJlYXNvbmVkIHRoYXQgdGhlIHBhZ2UgKGEgc2tpcHBhYmxlIHBhZ2UpIG11c3Qg aGF2ZSBhdCBsZWFzdCBiZWVuCmFsbC1mcm96ZW4gaW4gdGhlIHJlY2VudCBwYXN0LCBzbyBza2lw cGluZyBpdCB3b24ndCBtYWtlIHJlbGZyb3plbnhpZAphZHZhbmNlbWVudCB1bnNhZmUgKHdoaWNo IGlzIG5ldmVyIG9rYXkgZm9yIGFnZ3Jlc3NpdmUgVkFDVVVNcykuCgpUaGUgcmVjaGVjayBjcmVh dGVkIGEgd2luZG93IGZvciBzb21lIG90aGVyIGJhY2tlbmQgdG8gY29uZnVzZSBtYXR0ZXJzCmZv ciBWQUNVVU0uICBJZiB0aGUgcGFnZSdzIFZNIGJpdCB0dXJuZWQgb3V0IHRvIGJlIHVuc2V0LCBW QUNVVU0gd291bGQKY29uY2x1ZGUgdGhhdCB0aGUgcGFnZSB3YXMgX25ldmVyXyBhbGwtZnJvemVu LiAgZnJvemVuc2tpcHBlZF9wYWdlcyB3YXMKbm90IGluY3JlbWVudGVkLCBhbmQgeWV0IFZBQ1VV TSBjb3VsZG4ndCBiYWNrIG91dCBvZiBza2lwcGluZyBhdCB0aGlzCmxhdGUgc3RhZ2UgKGl0IGNv dWxkbid0IGNob29zZSB0byBzY2FuIHRoZSBwYWdlIGluc3RlYWQpLiAgVGhpcyBtYWRlIGl0CnVu c2FmZSB0byBhZHZhbmNlIHJlbGZyb3plbnhpZCBsYXRlciBvbi4KCkNvbnNpc3RlbnRseSBhdm9p ZCB0aGUgaXNzdWUgYnkgZ2VuZXJhbGl6aW5nIGhvdyB3ZSBza2lwIGZyb3plbiBwYWdlcwpkdXJp bmcgYWdncmVzc2l2ZSBWQUNVVU1zOiB0YWtlIHRoZSBzYW1lIGFwcHJvYWNoIHdoZW4gc2tpcHBp bmcgYW55CnNraXBwYWJsZSBwYWdlIHJhbmdlIGR1cmluZyBhZ2dyZXNzaXZlIGFuZCBub24tYWdn cmVzc2l2ZSBWQUNVVU1zIGFsaWtlLgpUaGUgbmV3IGFwcHJvYWNoIG1ha2VzIHJhbmdlcyAobm90 IGluZGl2aWR1YWwgcGFnZXMpIHRoZSBmdW5kYW1lbnRhbAp1bml0IG9mIHNraXBwaW5nIHVzaW5n IHRoZSB2aXNpYmlsaXR5IG1hcC4gIGZyb3plbnNraXBwZWRfcGFnZXMgaXMKcmVwbGFjZWQgd2l0 aCBhIGJvb2xlYW4gZmxhZyB0aGF0IHJlcHJlc2VudHMgd2hldGhlciBzb21lIHNraXBwYWJsZQpy YW5nZSB3aXRoIG9uZSBvciBtb3JlIGFsbC12aXNpYmxlIHBhZ2VzIHdhcyBhY3R1YWxseSBza2lw cGVkLgoKSXQgaXMgc2FmZSBmb3IgVkFDVVVNIHRvIHRyZWF0IGEgcGFnZSBhcyBhbGwtZnJvemVu IHByb3ZpZGVkIGl0IGF0IGxlYXN0CmhhZCBpdHMgYWxsLWZyb3plbiBiaXQgc2V0IGFmdGVyIHRo ZSBPbGRlc3RYbWluIGN1dG9mZiB3YXMgZXN0YWJsaXNoZWQuClZBQ1VVTSBpcyBvbmx5IHJlcXVp cmVkIHRvIHNjYW4gcGFnZXMgdGhhdCBtaWdodCBoYXZlIFhJRHMgPCBPbGRlc3RYbWluCih1bmZy b3plbiBYSURzKSB0byBiZSBhYmxlIHRvIHNhZmVseSBhZHZhbmNlIHJlbGZyb3plbnhpZC4gIFR1 cGxlcwpjb25jdXJyZW50bHkgaW5zZXJ0ZWQgb24gInNraXBwZWQiIHBhZ2VzIGNhbiBiZSB0aG91 Z2h0IG9mIGFzIGVxdWl2YWxlbnQKdG8gdHVwbGVzIGNvbmN1cnJlbnRseSBpbnNlcnRlZCBvbiBh IGJsb2NrID49IHJlbF9wYWdlcy4KCkl0J3MgcG9zc2libGUgdGhhdCB0aGUgaXNzdWUgdGhpcyBj b21taXQgZml4ZXMgaGFyZGx5IGV2ZXIgY2FtZSB1cCBpbgpwcmFjdGljZS4gIEJ1dCB3ZSBvbmx5 IGhhZCB0byBiZSB1bmx1Y2t5IG9uY2UgdG8gbG9zZSBvdXQgb24gYWR2YW5jaW5nCnJlbGZyb3pl bnhpZCAtLSBhIHNpbmdsZSBhZmZlY3RlZCBoZWFwIHBhZ2Ugd2FzIGVub3VnaCB0byB0aHJvdyBW QUNVVU0Kb2ZmLiAgVGhhdCBzZWVtcyBsaWtlIHNvbWV0aGluZyB0byBhdm9pZCBvbiBnZW5lcmFs IHByaW5jaXBsZS4gIFRoaXMgaXMKc2ltaWxhciB0byBhbiBpc3N1ZSBmaXhlZCBieSBjb21taXQg NDRmYTg0ODgsIHdoaWNoIHRhdWdodCB2YWN1dW1sYXp5LmMKdG8gbm90IGdpdmUgdXAgb24gbm9u LWFnZ3Jlc3NpdmUgcmVsZnJvemVueGlkIGFkdmFuY2VtZW50IGp1c3QgYmVjYXVzZSBhCmNsZWFu dXAgbG9jayB3YXNuJ3QgaW1tZWRpYXRlbHkgYXZhaWxhYmxlIG9uIHNvbWUgaGVhcCBwYWdlLgoK U2tpcHBpbmcgYW4gYWxsLXZpc2libGUgcmFuZ2UgaXMgbm93IGV4cGxpY2l0bHkgc3RydWN0dXJl ZCBhcyBhIGNob2ljZQptYWRlIGJ5IG5vbi1hZ2dyZXNzaXZlIFZBQ1VVTXMsIGJ5IHdlaWdoaW5n IGtub3duIGNvc3RzIChzY2FubmluZyBleHRyYQpza2lwcGFibGUgcGFnZXMgdG8gZnJlZXplIHRo ZWlyIHR1cGxlcyBlYXJseSkgYWdhaW5zdCBrbm93biBiZW5lZml0cwooYWR2YW5jaW5nIHJlbGZy b3plbnhpZCBlYXJseSkuICBUaGlzIHdvcmtzIGluIGVzc2VudGlhbGx5IHRoZSBzYW1lIHdheQph cyBpdCBhbHdheXMgaGFzIChkb24ndCBza2lwIHJhbmdlcyA8IFNLSVBfUEFHRVNfVEhSRVNIT0xE KS4gIFdlIGNvdWxkCmRvIG11Y2ggYmV0dGVyIGhlcmUgaW4gdGhlIGZ1dHVyZSBieSBjb25zaWRl cmluZyBvdGhlciByZWxldmFudCBmYWN0b3JzLgoKQXV0aG9yOiBQZXRlciBHZW9naGVnYW4gPHBn QGJvd3QuaWU+ClJldmlld2VkLUJ5OiBSb2JlcnQgSGFhcyA8cm9iZXJ0bWhhYXNAZ21haWwuY29t PgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBSDItV3puNmJHSkdmT3kzelNUSmlj S0x3OTlQSEplU09RQk9WaUtqU0NpbmF4VUtEUUBtYWlsLmdtYWlsLmNvbQpEaXNjdXNzaW9uOiBo dHRwczovL3Bvc3Rnci5lcy9tL0NBJTJCVGdtb1ppU09ZNkg3YWFkdzVaWkdtN3pZbWZEekw2bndt TDVWN0dMNEhnSmdMRl93JTQwbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpE ZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9m M2MxNWNiZTUwNjVmOGM0ZmI5MDJhZjhmODEwYTgwNjFhODAyNDE3CgpNb2RpZmllZCBGaWxlcwot LS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9hY2Nlc3MvaGVhcC92YWN1dW1sYXp5LmMgfCAzMDkg KysrKysrKysrKysrKysrKystLS0tLS0tLS0tLS0tLS0tLS0KMSBmaWxlIGNoYW5nZWQsIDE0NiBp bnNlcnRpb25zKCspLCAxNjMgZGVsZXRpb25zKC0pCgo= --===============8206871953978029682==--