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 1pKo3p-0001bi-GZ for pgsql-committers@arkaria.postgresql.org; Wed, 25 Jan 2023 22:16:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pKo3n-0006aN-UQ for pgsql-committers@arkaria.postgresql.org; Wed, 25 Jan 2023 22:16:03 +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 1pKo3n-0006Zs-NO for pgsql-committers@lists.postgresql.org; Wed, 25 Jan 2023 22:16:03 +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 1pKo3k-0006dw-Jf for pgsql-committers@lists.postgresql.org; Wed, 25 Jan 2023 22:16:02 +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 1pKo3k-00048g-73 for pgsql-committers@lists.postgresql.org; Wed, 25 Jan 2023 22:16:00 +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 1pKo3i-005TBD-QS for pgsql-committers@lists.postgresql.org; Wed, 25 Jan 2023 22:15:59 +0000 Content-Type: multipart/mixed; boundary="===============1638835444367802461==" MIME-Version: 1.0 From: Peter Geoghegan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add eager and lazy freezing strategies to VACUUM. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 25 Jan 2023 22:15:59 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1638835444367802461== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIGVhZ2VyIGFuZCBsYXp5IGZyZWV6aW5nIHN0cmF0ZWdpZXMgdG8gVkFDVVVNLgoKRWFnZXIg ZnJlZXppbmcgc3RyYXRlZ3kgYXZvaWRzIGxhcmdlIGJ1aWxkLXVwcyBvZiBhbGwtdmlzaWJsZSBw YWdlcy4gIEl0Cm1ha2VzIFZBQ1VVTSB0cmlnZ2VyIHBhZ2UtbGV2ZWwgZnJlZXppbmcgd2hlbmV2 ZXIgZG9pbmcgc28gd2lsbCBlbmFibGUKdGhlIHBhZ2UgdG8gYmVjb21lIGFsbC1mcm96ZW4gaW4g dGhlIHZpc2liaWxpdHkgbWFwLiAgVGhpcyBpcyB1c2VmdWwgZm9yCnRhYmxlcyB0aGF0IGV4cGVy aWVuY2UgY29udGludWFsIGdyb3d0aCwgcGFydGljdWxhcmx5IHN0cmljdCBhcHBlbmQtb25seQp0 YWJsZXMgc3VjaCBhcyBwZ2JlbmNoJ3MgaGlzdG9yeSB0YWJsZS4gIEVhZ2VyIGZyZWV6aW5nIHNp Z25pZmljYW50bHkKaW1wcm92ZXMgcGVyZm9ybWFuY2Ugc3RhYmlsaXR5IGJ5IHNwcmVhZGluZyBv dXQgdGhlIGNvc3Qgb2YgZnJlZXppbmcKb3ZlciB0aW1lLCByYXRoZXIgdGhhbiBkb2luZyBtb3N0 IGZyZWV6aW5nIGR1cmluZyBhZ2dyZXNzaXZlIFZBQ1VVTXMuCkl0IGNvbXBsZW1lbnRzIHRoZSBp bnNlcnQgYXV0b3ZhY3V1bSBtZWNoYW5pc20gYWRkZWQgYnkgY29tbWl0IGIwNzY0MmRiLgoKVkFD VVVNIGRldGVybWluZXMgaXRzIGZyZWV6aW5nIHN0cmF0ZWd5IGJhc2VkIG9uIHRoZSB2YWx1ZSBv ZiB0aGUgbmV3CnZhY3V1bV9mcmVlemVfc3RyYXRlZ3lfdGhyZXNob2xkIEdVQyAob3IgcmVsb3B0 aW9uKSB3aXRoIGxvZ2dlZCB0YWJsZXMuClRhYmxlcyB0aGF0IGV4Y2VlZCB0aGUgc2l6ZSB0aHJl c2hvbGQgdXNlIHRoZSBlYWdlciBmcmVlemluZyBzdHJhdGVneS4KVW5sb2dnZWQgdGFibGVzIGFu ZCB0ZW1wIHRhYmxlcyBhbHdheXMgdXNlIGVhZ2VyIGZyZWV6aW5nIHN0cmF0ZWd5LApzaW5jZSB0 aGUgYWRkZWQgY29zdCBpcyBuZWdsaWdpYmxlIHRoZXJlLiAgTm9uLXBlcm1hbmVudCByZWxhdGlv bnMgd29uJ3QKaW5jdXIgYW55IGV4dHJhIG92ZXJoZWFkIGluIFdBTCB3cml0dGVuIChmb3IgdGhl IG9idmlvdXMgcmVhc29uKSwgbm9yIGluCnBhZ2VzIGRpcnRpZWQgKHNpbmNlIGFueSBleHRyYSBm cmVlemluZyB3aWxsIG9ubHkgdGFrZSBwbGFjZSBvbiBwYWdlcwp3aG9zZSBQRF9BTExfVklTSUJM RSBiaXQgbmVlZGVkIHRvIGJlIHNldCBlaXRoZXIgd2F5KS4KClZBQ1VVTSB1c2VzIGxhenkgZnJl ZXppbmcgc3RyYXRlZ3kgZm9yIGxvZ2dlZCB0YWJsZXMgdGhhdCBmYWxsIHVuZGVyIHRoZQpHVUMg c2l6ZSB0aHJlc2hvbGQuICBQYWdlLWxldmVsIGZyZWV6aW5nIHRyaWdnZXJzIGJhc2VkIG9uIHRo ZSBjcml0ZXJpYQplc3RhYmxpc2hlZCBpbiBjb21taXQgMWRlNThkZjQsIHdoaWNoIGFkZGVkIGJh c2ljIHBhZ2UtbGV2ZWwgZnJlZXppbmcuCgpFYWdlciBmcmVlemluZyBpcyBzdHJpY3RseSBtb3Jl IGFnZ3Jlc3NpdmUgdGhhbiBsYXp5IGZyZWV6aW5nLiAgU2V0dGluZ3MKbGlrZSB2YWN1dW1fZnJl ZXplX21pbl9hZ2Ugc3RpbGwgZ2V0IGFwcGxpZWQgaW4ganVzdCB0aGUgc2FtZSB3YXkgaW4KZXZl cnkgVkFDVVVNLCBpbmRlcGVuZGVudCBvZiB0aGUgc3RyYXRlZ3kgaW4gdXNlLiAgVGhlIG9ubHkg bWVjaGFuaWNhbApkaWZmZXJlbmNlIGJldHdlZW4gZWFnZXIgYW5kIGxhenkgZnJlZXppbmcgc3Ry YXRlZ2llcyBpcyB0aGF0IG9ubHkgdGhlCmZvcm1lciBhcHBsaWVzIGl0cyBvd24gYWRkaXRpb25h bCBjcml0ZXJpYSB0byB0cmlnZ2VyIGZyZWV6aW5nIHBhZ2VzLgpOb3RlIHRoYXQgZXZlbiBsYXp5 IGZyZWV6aW5nIHN0cmF0ZWd5IHdpbGwgdHJpZ2dlciBmcmVlemluZyB3aGVuZXZlciBhCnBhZ2Ug aGFwcGVucyB0byBoYXZlIHJlcXVpcmVkIHRoYXQgYW4gRlBJIGJlIHdyaXR0ZW4gZHVyaW5nIHBy dW5pbmcsCnByb3ZpZGVkIHRoYXQgdGhlIHBhZ2Ugd2lsbCB0aGVyZWJ5IGJlY29tZSBhbGwtZnJv emVuIGluIHRoZSB2aXNpYmlsaXR5Cm1hcCBhZnRlcndhcmRzIChkdWUgdG8gdGhlIEZQSSBvcHRp bWl6YXRpb24gZnJvbSBjb21taXQgMWRlNThkZjQpLgoKVGhlIHZhY3V1bV9mcmVlemVfc3RyYXRl Z3lfdGhyZXNob2xkIGRlZmF1bHQgc2V0dGluZyBpcyA0R0IuICBUaGlzIGlzIGEKcmVsYXRpdmVs eSBsb3cgc2V0dGluZyB0aGF0IHByaW9yaXRpemVzIHBlcmZvcm1hbmNlIHN0YWJpbGl0eS4gIEl0 IHdpbGwKYmUgcmV2aWV3ZWQgYXQgdGhlIGVuZCBvZiB0aGUgUG9zdGdyZXMgMTYgYmV0YSBwZXJp b2QuCgpBdXRob3I6IFBldGVyIEdlb2doZWdhbiA8cGdAYm93dC5pZT4KUmV2aWV3ZWQtQnk6IEpl ZmYgRGF2aXMgPHBnc3FsQGotZGF2aXMuY29tPgpSZXZpZXdlZC1CeTogQW5kcmVzIEZyZXVuZCA8 YW5kcmVzQGFuYXJhemVsLmRlPgpSZXZpZXdlZC1CeTogTWF0dGhpYXMgdmFuIGRlIE1lZW50IDxi b2VrZXd1cm0rcG9zdGdyZXNAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5l cy9tL0NBSDItV3prRm9rXzZFQUh1SzM5R2FXNEZqRUZRc1k9M0owQUFkNkZYazkzdS1YcTNGZ0Bt YWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRw czovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzRkNDE3OTkyNjEzOTQ5YWYzNTUz MGI0ZThlODM2NzBjNGU2N2UxYjIKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9z cmMvc2dtbC9jb25maWcuc2dtbCAgICAgICAgICAgICAgICAgICAgICB8IDMwICsrKysrKysrKysr KysrKysKZG9jL3NyYy9zZ21sL21haW50ZW5hbmNlLnNnbWwgICAgICAgICAgICAgICAgIHwgNTAg KysrKysrKysrKysrKysrKysrKystLS0tLS0tCmRvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3RhYmxl LnNnbWwgICAgICAgICAgICB8IDE0ICsrKysrKysrCnNyYy9iYWNrZW5kL2FjY2Vzcy9jb21tb24v cmVsb3B0aW9ucy5jICAgICAgICB8IDEwICsrKysrKwpzcmMvYmFja2VuZC9hY2Nlc3MvaGVhcC9o ZWFwYW0uYyAgICAgICAgICAgICAgfCAgMSArCnNyYy9iYWNrZW5kL2FjY2Vzcy9oZWFwL3ZhY3V1 bWxhenkuYyAgICAgICAgICB8IDQzICsrKysrKysrKysrKysrKysrKysrKystCnNyYy9iYWNrZW5k L2NvbW1hbmRzL3ZhY3V1bS5jICAgICAgICAgICAgICAgICB8IDI1ICsrKysrKysrKysrKystCnNy Yy9iYWNrZW5kL3Bvc3RtYXN0ZXIvYXV0b3ZhY3V1bS5jICAgICAgICAgICB8IDEwICsrKysrKwpz cmMvYmFja2VuZC91dGlscy9taXNjL2d1Y190YWJsZXMuYyAgICAgICAgICAgfCAxNCArKysrKysr KwpzcmMvYmFja2VuZC91dGlscy9taXNjL3Bvc3RncmVzcWwuY29uZi5zYW1wbGUgfCAgMSArCnNy Yy9pbmNsdWRlL2NvbW1hbmRzL3ZhY3V1bS5oICAgICAgICAgICAgICAgICB8IDEyICsrKysrKysK c3JjL2luY2x1ZGUvdXRpbHMvcmVsLmggICAgICAgICAgICAgICAgICAgICAgIHwgIDEgKwoxMiBm aWxlcyBjaGFuZ2VkLCAxOTcgaW5zZXJ0aW9ucygrKSwgMTQgZGVsZXRpb25zKC0pCgo= --===============1638835444367802461==--