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 1slEWe-006B61-6m for pgsql-general@arkaria.postgresql.org; Mon, 02 Sep 2024 21:23:53 +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 1slEWc-002rmy-NY for pgsql-general@arkaria.postgresql.org; Mon, 02 Sep 2024 21:23:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1slEWc-002rmp-Ap for pgsql-general@lists.postgresql.org; Mon, 02 Sep 2024 21:23:50 +0000 Received: from meesny.iki.fi ([2001:67c:2b0:1c1::201]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1slEWZ-000LsE-M5 for pgsql-general@lists.postgresql.org; Mon, 02 Sep 2024 21:23:49 +0000 Received: from [192.168.1.110] (dsl-hkibng22-54f8db-125.dhcp.inet.fi [84.248.219.125]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: hlinnaka) by meesny.iki.fi (Postfix) with ESMTPSA id 4WyMFD26BwzyQB; Tue, 3 Sep 2024 00:23:44 +0300 (EEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=meesny; t=1725312224; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=AK4H8Cp5njWVcygJqaJCX2sAWbknoC33/tuNsW/p28Y=; b=RZwIaumm/5auFzwGUDiK5gjwFWA0QTQM1UzC8DiHC07la5PfcH1uAERNp4p+qg+WXAOG2E lMyyFXVc0mJlCpyg4/ryVO3+F19RzSZpyN9FooapVMzDsGM/tuEVDcyExqfAA7GeMsg3Z9 NLP5WzanTFAP/fLA+/jmxShq1sfsG0E= ARC-Seal: i=1; s=meesny; d=iki.fi; t=1725312224; a=rsa-sha256; cv=none; b=KNWDD5ydqU7Fa1zIK3Q1bUwpFYjE4S/ZbwApbb9nZrXmTaK9NA47MUBb5c73LS0yOskyts E7FzIN3jf0vEnE9yZARLEv7aiAQJN54bKPiiQUtkzf9Wpp/mCibF3K3tjjmMwDWAQrwkut fcSVRp8PONpfBE7x1Rq73nhxOM7rvg8= ARC-Authentication-Results: i=1; ORIGINATING; auth=pass smtp.auth=hlinnaka smtp.mailfrom=hlinnaka@iki.fi ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=meesny; t=1725312224; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=AK4H8Cp5njWVcygJqaJCX2sAWbknoC33/tuNsW/p28Y=; b=nBg6W0SwfF4lFkM/YZuyG5bK39t7Egz8ag3qfw6VCWrDk3fMwUHTWnYHgNU0FyrIu5eY6w 8uiFZqEnctlQo8ZMHVMD3TbBQm+Dg45zxW42GHh3GSKa+azzmPludwWZ1aIbVcSfulQiGa oViS7xILZBSeGikxsRvQpB6zxuq4b1c= Message-ID: <4469b349-4ad6-422b-b6eb-567e9459041c@iki.fi> Date: Tue, 3 Sep 2024 00:23:43 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: PG17 optimizations to vacuum From: Heikki Linnakangas To: Peter Geoghegan , Pavel Luzanov Cc: Melanie Plageman , "pgsql-generallists.postgresql.org" References: <3bda0d10-0d60-42b7-9600-abe23d54bb16@postgrespro.ru> <7bc8da54-fe4f-4ff2-aa4e-b54fc91df586@postgrespro.ru> <7760d3e3-15cc-4abf-ab33-027008c17d53@iki.fi> Content-Language: en-US In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gMDMvMDkvMjAyNCAwMDoxMSwgSGVpa2tpIExpbm5ha2FuZ2FzIHdyb3RlOg0KPiBPbiAw My8wOS8yMDI0IDAwOjAxLCBQZXRlciBHZW9naGVnYW4gd3JvdGU6DQo+PiBPbiBNb24sIFNl cCAyLCAyMDI0IGF0IDQ6NTjigK9QTSBIZWlra2kgTGlubmFrYW5nYXMgPGhsaW5uYWthQGlr aS5maT4gDQo+PiB3cm90ZToNCj4+PiBEbyB5b3UgaGF2ZSBhbnkgbm9uLWRlZmF1bHQgc2V0 dGluZ3M/ICJzZWxlY3QgbmFtZSwNCj4+PiBjdXJyZW50X3NldHRpbmcobmFtZSksIHNvdXJj ZcKgIGZyb20gcGdfc2V0dGluZ3Mgd2hlcmUgc2V0dGluZyA8Pg0KPj4+IGJvb3RfdmFsOyIg d291bGQgc2hvdyB0aGF0Lg0KPj4NCj4+IFdoYXQgYWJvdXQgcGFnZSBjaGVja3N1bXM/DQo+ Pg0KPj4gT25lIHNpbXBsZSBleHBsYW5hdGlvbiBpcyB0aGF0IHdlJ3JlIHdyaXRpbmcgZXh0 cmEgRlBJcyB0byBzZXQgaGludA0KPj4gYml0cy4gQnV0IHRoYXQgZXhwbGFuYXRpb24gb25s eSB3b3JrcyBpZiB5b3UgYXNzdW1lIHRoYXQgcGFnZS1sZXZlbA0KPj4gY2hlY2tzdW1zIGFy ZSBpbiB1c2UgKG9yIHRoYXQgd2FsX2xvZ19oaW50cyBpcyB0dXJuZWQgb24pLg0KPiANCj4g SG1tLCB5ZWFoLCB0aGF0IG1pZ2h0IGJlIGl0LiBXaXRoIGNoY2Vrc3VtcyBlbmFibGVkLCBJ IHNlZSB+MTIwayBXQUwgDQo+IHJlY29yZHMsIHZzIH45MGsgd2l0aG91dCBjaGVja3N1bXMu IEJ1dCB0aGVyZSdzIG5vIGRpZmZlcmVuY2UgYmV0d2VlbiANCj4gdjE2IGFuZCBtYXN0ZXIu DQoNCkxvb2tpbmcgYXQgdGhlIHBnX3dhbGR1bXAgb3V0cHV0IGZyb20gdGhpcyB0ZXN0Og0K DQo+IC4uLiA+IHJtZ3I6IFhMT0cgICAgICAgIGxlbiAocmVjL3RvdCk6ICAgICA0OS8gIDgy MDksIHR4OiAgICAgICAgICAwLCBsc246IA0KMC9GRTA1MkFBOCwgcHJldiAwL0ZFMDUyOEE4 LCBkZXNjOiBGUElfRk9SX0hJTlQgLCBibGtyZWYgIzA6IHJlbCANCjE2NjMvNS8xNjM5NiBi bGsgNzMgRlBXDQo+IHJtZ3I6IEhlYXAyICAgICAgIGxlbiAocmVjL3RvdCk6ICAgIDUwNy8g ICA1MDcsIHR4OiAgICAgICAgICAwLCBsc246IDAvRkUwNTRBRDgsIHByZXYgMC9GRTA1MkFB OCwgZGVzYzogUFJVTkUgc25hcHNob3RDb25mbGljdEhvcml6b246IDc1NCwgbnJlZGlyZWN0 ZWQ6IDAsIG5kZWFkOiAyMjYsIG51bnVzZWQ6IDAsIHJlZGlyZWN0ZWQ6IFtdLCBkZWFkOiBb MSwgMiwgMywgNCwgNSwgNiwgNywgOCwgOSwgMTAsIDExLCAxMiwgMTMsIDE0LCAxNSwgMTYs IDE3LCAxOCwgMTksIDIwLCAyMSwgMjIsIDIzLCAyNCwgMjUsIDI2LCAyNywgMjgsIDI5LCAz MCwgMzEsIDMyLCAzMywgMzQsIDM1LCAzNiwgMzcsIDM4LCAzOSwgNDAsIDQxLCA0MiwgNDMs IDQ0LCA0NSwgNDYsIDQ3LCA0OCwgNDksIDUwLCA1MSwgNTIsIDUzLCA1NCwgNTUsIDU2LCA1 NywgNTgsIDU5LCA2MCwgNjEsIDYyLCA2MywgNjQsIDY1LCA2NiwgNjcsIDY4LCA2OSwgNzAs IDcxLCA3MiwgNzMsIDc0LCA3NSwgNzYsIDc3LCA3OCwgNzksIDgwLCA4MSwgODIsIDgzLCA4 NCwgODUsIDg2LCA4NywgODgsIDg5LCA5MCwgOTEsIDkyLCA5MywgOTQsIDk1LCA5NiwgOTcs IDk4LCA5OSwgMTAwLCAxMDEsIDEwMiwgMTAzLCAxMDQsIDEwNSwgMTA2LCAxMDcsIDEwOCwg MTA5LCAxMTAsIDExMSwgMTEyLCAxMTMsIDExNCwgMTE1LCAxMTYsIDExNywgMTE4LCAxMTks IDEyMCwgMTIxLCAxMjIsIDEyMywgMTI0LCAxMjUsIDEyNiwgMTI3LCAxMjgsIDEyOSwgMTMw LCAxMzEsIDEzMiwgMTMzLCAxMzQsIDEzNSwgMTM2LCAxMzcsIDEzOCwgMTM5LCAxNDAsIDE0 MSwgMTQyLCAxNDMsIDE0NCwgMTQ1LCAxNDYsIDE0NywgMTQ4LCAxNDksIDE1MCwgMTUxLCAx NTIsIDE1MywgMTU0LCAxNTUsIDE1NiwgMTU3LCAxNTgsIDE1OSwgMTYwLCAxNjEsIDE2Miwg MTYzLCAxNjQsIDE2NSwgMTY2LCAxNjcsIDE2OCwgMTY5LCAxNzAsIDE3MSwgMTcyLCAxNzMs IDE3NCwgMTc1LCAxNzYsIDE3NywgMTc4LCAxNzksIDE4MCwgMTgxLCAxODIsIDE4MywgMTg0 LCAxODUsIDE4NiwgMTg3LCAxODgsIDE4OSwgMTkwLCAxOTEsIDE5MiwgMTkzLCAxOTQsIDE5 NSwgMTk2LCAxOTcsIDE5OCwgMTk5LCAyMDAsIDIwMSwgMjAyLCAyMDMsIDIwNCwgMjA1LCAy MDYsIDIwNywgMjA4LCAyMDksIDIxMCwgMjExLCAyMTIsIDIxMywgMjE0LCAyMTUsIDIxNiwg MjE3LCAyMTgsIDIxOSwgMjIwLCAyMjEsIDIyMiwgMjIzLCAyMjQsIDIyNSwgMjI2XSwgdW51 c2VkOiBbXSwgYmxrcmVmICMwOiByZWwgMTY2My81LzE2Mzk2IGJsayA3Mw0KPiBybWdyOiBY TE9HICAgICAgICBsZW4gKHJlYy90b3QpOiAgICAgNDkvICA4MjA5LCB0eDogICAgICAgICAg MCwgbHNuOiAwL0ZFMDU0Q0Q4LCBwcmV2IDAvRkUwNTRBRDgsIGRlc2M6IEZQSV9GT1JfSElO VCAsIGJsa3JlZiAjMDogcmVsIDE2NjMvNS8xNjM5NiBibGsgNzQgRlBXDQo+IHJtZ3I6IEhl YXAyICAgICAgIGxlbiAocmVjL3RvdCk6ICAgIDUwNy8gICA1MDcsIHR4OiAgICAgICAgICAw LCBsc246IDAvRkUwNTZEMDgsIHByZXYgMC9GRTA1NENEOCwgZGVzYzogUFJVTkUgc25hcHNo b3RDb25mbGljdEhvcml6b246IDc1NCwgbnJlZGlyZWN0ZWQ6IDAsIG5kZWFkOiAyMjYsIG51 bnVzZWQ6IDAsIHJlZGlyZWN0ZWQ6IFtdLCBkZWFkOiBbMSwgMiwgMywgNCwgNSwgNiwgNywg OCwgOSwgMTAsIDExLCAxMiwgMTMsIDE0LCAxNSwgMTYsIDE3LCAxOCwgMTksIDIwLCAyMSwg MjIsIDIzLCAyNCwgMjUsIDI2LCAyNywgMjgsIDI5LCAzMCwgMzEsIDMyLCAzMywgMzQsIDM1 LCAzNiwgMzcsIDM4LCAzOSwgNDAsIDQxLCA0MiwgNDMsIDQ0LCA0NSwgNDYsIDQ3LCA0OCwg NDksIDUwLCA1MSwgNTIsIDUzLCA1NCwgNTUsIDU2LCA1NywgNTgsIDU5LCA2MCwgNjEsIDYy LCA2MywgNjQsIDY1LCA2NiwgNjcsIDY4LCA2OSwgNzAsIDcxLCA3MiwgNzMsIDc0LCA3NSwg NzYsIDc3LCA3OCwgNzksIDgwLCA4MSwgODIsIDgzLCA4NCwgODUsIDg2LCA4NywgODgsIDg5 LCA5MCwgOTEsIDkyLCA5MywgOTQsIDk1LCA5NiwgOTcsIDk4LCA5OSwgMTAwLCAxMDEsIDEw MiwgMTAzLCAxMDQsIDEwNSwgMTA2LCAxMDcsIDEwOCwgMTA5LCAxMTAsIDExMSwgMTEyLCAx MTMsIDExNCwgMTE1LCAxMTYsIDExNywgMTE4LCAxMTksIDEyMCwgMTIxLCAxMjIsIDEyMywg MTI0LCAxMjUsIDEyNiwgMTI3LCAxMjgsIDEyOSwgMTMwLCAxMzEsIDEzMiwgMTMzLCAxMzQs IDEzNSwgMTM2LCAxMzcsIDEzOCwgMTM5LCAxNDAsIDE0MSwgMTQyLCAxNDMsIDE0NCwgMTQ1 LCAxNDYsIDE0NywgMTQ4LCAxNDksIDE1MCwgMTUxLCAxNTIsIDE1MywgMTU0LCAxNTUsIDE1 NiwgMTU3LCAxNTgsIDE1OSwgMTYwLCAxNjEsIDE2MiwgMTYzLCAxNjQsIDE2NSwgMTY2LCAx NjcsIDE2OCwgMTY5LCAxNzAsIDE3MSwgMTcyLCAxNzMsIDE3NCwgMTc1LCAxNzYsIDE3Nywg MTc4LCAxNzksIDE4MCwgMTgxLCAxODIsIDE4MywgMTg0LCAxODUsIDE4NiwgMTg3LCAxODgs IDE4OSwgMTkwLCAxOTEsIDE5MiwgMTkzLCAxOTQsIDE5NSwgMTk2LCAxOTcsIDE5OCwgMTk5 LCAyMDAsIDIwMSwgMjAyLCAyMDMsIDIwNCwgMjA1LCAyMDYsIDIwNywgMjA4LCAyMDksIDIx MCwgMjExLCAyMTIsIDIxMywgMjE0LCAyMTUsIDIxNiwgMjE3LCAyMTgsIDIxOSwgMjIwLCAy MjEsIDIyMiwgMjIzLCAyMjQsIDIyNSwgMjI2XSwgdW51c2VkOiBbXSwgYmxrcmVmICMwOiBy ZWwgMTY2My81LzE2Mzk2IGJsayA3NA0KPiAuLi4NCg0KVGhlIHBhdHRlcm4gb2YgV0FMIHJl Y29yZHMgd2l0aCBjaGVja3N1bXMgZW5hYmxlZCBpcyBzaWxseTogRm9yIGVhY2ggDQpwYWdl LCB3ZSBmaXJzdCB3cml0ZSBhbiBGUEkgcmVjb3JkLCBhbiBpbW1lZGlhdGVseSBhZnRlciB0 aGF0IGEgUFJVTkUgDQpyZWNvcmQgdGhhdCByZW1vdmVzIGFsbCB0aGUgdHVwbGVzIG9uIGl0 LCBsZWF2aW5nIHRoZSBwYWdlIGVtcHR5Lg0KDQpUaGlzIGlzIHRoZSBzYW1lIHdpdGggdjE2 IGFuZCB2MTcsIGJ1dCB3ZSBjZXJ0YWlubHkgbGVmdCBtb25leSBvbiB0aGUgDQp0YWJsZSBi eSBub3QgZm9sZGluZyB0aGF0IEZQSSBpbnRvIHRoZSBWQUNVVU0vUFJVTkUgcmVjb3JkLg0K DQotLSANCkhlaWtraSBMaW5uYWthbmdhcw0KTmVvbiAoaHR0cHM6Ly9uZW9uLnRlY2gpDQoN Cg==