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.96) (envelope-from ) id 1wUTKX-001BKd-1r for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Jun 2026 17:55:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wUTKV-00FNXa-1Q for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Jun 2026 17:55:07 +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.96) (envelope-from ) id 1wUTKV-00FNXR-0S for pgsql-hackers@lists.postgresql.org; Tue, 02 Jun 2026 17:55:07 +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.98.2) (envelope-from ) id 1wUTKT-00000000mZy-0Yvc for pgsql-hackers@lists.postgresql.org; Tue, 02 Jun 2026 17:55:06 +0000 Received: from coridan.postgresql.org ([2001:4800:3e1:1::213]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wUTKS-002PHb-0R for pgsql-hackers@lists.postgresql.org; Tue, 02 Jun 2026 17:55:04 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wUTKR-001sjX-22 for pgsql-hackers@lists.postgresql.org; Tue, 02 Jun 2026 17:55:03 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: generic plans and "initial" pruning To: pgsql-hackers@lists.postgresql.org From: Ilmar Yunusov Cc: Amit Langote Date: Tue, 02 Jun 2026 17:54:09 +0000 User-Agent: pgcommitfest X-cfsender: tanswis42.gmail.com In-Reply-To: References: Message-ID: <178042284979.1017.17926732655528064040.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhlIGZvbGxvd2luZyByZXZpZXcgaGFzIGJlZW4gcG9zdGVkIHRocm91Z2ggdGhlIGNvbW1pdGZl c3QgYXBwbGljYXRpb246Cm1ha2UgaW5zdGFsbGNoZWNrLXdvcmxkOiAgbm90IHRlc3RlZApJbXBs ZW1lbnRzIGZlYXR1cmU6ICAgICAgIHRlc3RlZCwgZmFpbGVkClNwZWMgY29tcGxpYW50OiAgICAg ICAgICAgbm90IHRlc3RlZApEb2N1bWVudGF0aW9uOiAgICAgICAgICAgIG5vdCB0ZXN0ZWQKCkhp LA0KDQpJIGxvb2tlZCBhdCB2MTMsIGZvY3VzaW5nIG9uIGFwcGx5L2J1aWxkIHN0YXR1cyBhbmQg cmVsYXRpb24tbG9jayBiZWhhdmlvciBmb3INCnJldXNlZCBnZW5lcmljIHBsYW5zIGFmdGVyIGlu aXRpYWwgcGFydGl0aW9uIHBydW5pbmcuDQoNCkkgdXNlZCB0aGUgdjEzIHNlcmllcyBmcm9tIEFt aXQncyAyMDI2LTA1LTI5IG1lc3NhZ2UsIG9uIG9yaWdpbi9tYXN0ZXIgYXQNCjRiMGJmMDc4OGIw NjZhNGNhMWQ0Zjk1OTU2NjY3OGU0NGVjOTM0MjIuDQoNClRoZSBzZXJpZXMgYXBwbGllcyBjbGVh bmx5IHdpdGggZ2l0IGFtLCBhbmQgZ2l0IGRpZmYgLS1jaGVjayByZXBvcnRzIG5vDQppc3N1ZXMu DQoNCkkgZmlyc3QgYnVpbHQgd2l0aDoNCg0KLi9jb25maWd1cmUgLS1wcmVmaXg9IiRQV0QvcGct aW5zdGFsbCIgLS13aXRob3V0LXJlYWRsaW5lIC0td2l0aG91dC16bGliIC0td2l0aG91dC1pY3UN Cm1ha2UgLXMgLWo4DQptYWtlIC1zIGluc3RhbGwNCg0KbWFrZSAtQyBzcmMvdGVzdC9yZWdyZXNz IGNoZWNrDQoNCnBhc3NlZDsgYWxsIDI0NSB0ZXN0cyBwYXNzZWQsIGluY2x1ZGluZyBwbGFuY2Fj aGUgYW5kIHBhcnRpdGlvbl9wcnVuZS4NCg0KSSBhbHNvIGJ1aWx0IGEgY2Fzc2VydC9kZWJ1ZyB0 cmVlIHdpdGg6DQoNCi4vY29uZmlndXJlIC0tcHJlZml4PSIkUFdEL3BnLWluc3RhbGwiIC0td2l0 aG91dC1yZWFkbGluZSAtLXdpdGhvdXQtemxpYiAtLXdpdGhvdXQtaWN1IC0tZW5hYmxlLWNhc3Nl cnQgLS1lbmFibGUtZGVidWcgJ0NGTEFHUz0tTzAgLWcnDQptYWtlIC1zIC1qOA0KbWFrZSAtcyBp bnN0YWxsDQoNCmFuZCByYW46DQoNCm1ha2UgLUMgc3JjL3Rlc3QvcmVncmVzcyBjaGVjaw0KDQp3 aGljaCBhbHNvIHBhc3NlZDsgYWxsIDI0NSB0ZXN0cyBwYXNzZWQuDQoNCkZvciB0aGUgbG9jayBi ZWhhdmlvciwgSSB1c2VkIGEgbGlzdC1wYXJ0aXRpb25lZCB0YWJsZSB3aXRoIGZvcmNlX2dlbmVy aWNfcGxhbi4NCkFmdGVyIHRoZSBnZW5lcmljIHBsYW4gaGFkIGJlZW4gYnVpbHQgYW5kIHRoZW4g cmV1c2VkLCBFWEVDVVRFIGhlbGQgb25seSB0aGUNCm1hdGNoaW5nIGNoaWxkIHBhcnRpdGlvbiBs b2NrLiBGb3IgZXhhbXBsZSwgRVhFQ1VURSBxKDEpIGhlbGQgb25seSB0aGUNCmZvbGxvd2luZyBj aGlsZCBsb2NrOg0KDQptYW51YWxfcHJ1bmVsb2NrX3AxDQoNCkVYUExBSU4gRVhFQ1VURSBiZWhh dmVkIHRoZSBzYW1lIHdheSBvbiBhIHJldXNlZCBnZW5lcmljIHBsYW47IEVYUExBSU4gRVhFQ1VU RQ0KcSgyKSByZW1vdmVkIHRoZSBvdGhlciBzdWJwbGFucyBhbmQgaGVsZCBvbmx5IHRoZSBmb2xs b3dpbmcgY2hpbGQgbG9jazoNCg0KbWFudWFsX3BydW5lbG9ja19wMg0KDQpXaXRoIGVuYWJsZV9w YXJ0aXRpb25fcHJ1bmluZyA9IG9mZiBhbmQgYSBuZXdseSBwcmVwYXJlZCBzdGF0ZW1lbnQsIGV4 ZWN1dGluZw0KdGhlIHNhbWUgU0VMRUNUIGhlbGQgYWxsIGNoaWxkIHBhcnRpdGlvbiBsb2NrczoN Cg0KbWFudWFsX3BydW5lbG9ja19wMSwgbWFudWFsX3BydW5lbG9ja19wMiwgbWFudWFsX3BydW5l bG9ja19wMw0KDQpJIGFsc28gcmFuIGEgYm91bmRlZCBjYXNzZXJ0L2RlYnVnIHN0cmVzcyBjaGVj ayBhcm91bmQgcGxhbiBpbnZhbGlkYXRpb24uIEl0DQpkaWQgMjAgY3ljbGVzIHdoZXJlIGEgY2hp bGQgaW5kZXggd2FzIGNyZWF0ZWQgYW5kIGRyb3BwZWQgYmVmb3JlIEVYRUNVVEUsIGFuZA0KMjAg c2ltaWxhciBjeWNsZXMgYmVmb3JlIEVYUExBSU4gRVhFQ1VURS4gSW4gZWFjaCBjeWNsZSwgdGhl IGZpcnN0IGV4ZWN1dGlvbg0KYWZ0ZXIgaW52YWxpZGF0aW9uL3JlcGxhbm5pbmcgaGVsZCBhbGwg Y2hpbGQgcGFydGl0aW9uIGxvY2tzLCBhbmQgdGhlIG5leHQNCmV4ZWN1dGlvbiByZXVzaW5nIHRo ZSBnZW5lcmljIHBsYW4gaGVsZCBvbmx5IHRoZSBtYXRjaGluZyBjaGlsZCBwYXJ0aXRpb24gbG9j ay4NClRoYXQgbWF0Y2hlcyBteSByZWFkaW5nIHRoYXQgdGhlIHBhdGNoIGlzIHJlZHVjaW5nIGxv Y2tzIGZvciByZXVzZWQgZ2VuZXJpYw0KcGxhbnMsIG5vdCBmb3IgdGhlIGV4ZWN1dGlvbiB0aGF0 IGhhcyB0byByZWJ1aWxkIHRoZSBwbGFuLg0KDQpPbmUgYmVoYXZpb3IgSSB3YW50ZWQgdG8gY29u ZmlybTogcHJlcGFyZWQgVVBEQVRFIGV4ZWN1dGlvbiBzdGlsbCBoZWxkIGFsbA0KY2hpbGQgcGFy dGl0aW9uIGxvY2tzIGluIG15IG1hbnVhbCBjaGVjaywgaW5jbHVkaW5nIG9uIHRoZSBzZWNvbmQg ZXhlY3V0aW9uDQp3aGVyZSB0aGUgZ2VuZXJpYyBwbGFuIHdhcyBiZWluZyByZXVzZWQuDQoNClRo ZSB0ZXN0IHdhczoNCg0KcHJlcGFyZSB1cGQoaW50LCB0ZXh0KSBhcw0KICB1cGRhdGUgc3RyZXNz X3BydW5lbG9ja19wIHNldCBiID0gJDIgd2hlcmUgYSA9ICQxOw0KDQpUaGVuIGJvdGg6DQoNCmV4 ZWN1dGUgdXBkKDMsICd1cGRhdGVkLXJvdy0zJyk7DQoNCmFuZCBhbiBhbGwtcHJ1bmVkIHZhbHVl Og0KDQpleGVjdXRlIHVwZCg5OSwgJ25vLXJvdycpOw0KDQpoZWxkOg0KDQpzdHJlc3NfcHJ1bmVs b2NrX3AxLCBzdHJlc3NfcHJ1bmVsb2NrX3AyLCBzdHJlc3NfcHJ1bmVsb2NrX3AzLA0Kc3RyZXNz X3BydW5lbG9ja19wNA0KDQpwZ19wcmVwYXJlZF9zdGF0ZW1lbnRzIHNob3dlZCBnZW5lcmljX3Bs YW5zIGluY3JlYXNpbmcgZm9yIHRoaXMgcHJlcGFyZWQNCnN0YXRlbWVudCwgc28gdGhpcyB3YXMg bm90IGEgY3VzdG9tLXBsYW4gY2FzZS4NCg0KSXMgdGhpcyBleHBlY3RlZCBmb3IgTW9kaWZ5VGFi bGUvcmVzdWx0IHJlbGF0aW9ucyBpbiB2MTMsIG9yIGRpZCBJIG1pc3MgYW4NCmVsaWdpYmlsaXR5 IGNvbmRpdGlvbiB0aGF0IHByZXZlbnRzIHBydW5pbmctYXdhcmUgbG9ja2luZyBmcm9tIGJlaW5n IHVzZWQgZm9yDQp0aGlzIHByZXBhcmVkIFVQREFURSBjYXNlPyBJIHNhdyB0aGUgcmVjZW50IGZp cnN0UmVzdWx0UmVscyBkaXNjdXNzaW9uLCBidXQgSQ0Kd2FzIG5vdCBzdXJlIHdoZXRoZXIgdGhv c2UgY2hhbmdlcyBhcmUgaW50ZW5kZWQgb25seSB0byBtYWtlIHBydW5lZA0KcmVzdWx0LXJlbGF0 aW9uIGluaXRpYWxpemF0aW9uIHNhZmUsIG9yIHdoZXRoZXIgYWN0dWFsIHByZXBhcmVkIERNTCBl eGVjdXRpb24NCmlzIGV4cGVjdGVkIHRvIHNlZSByZWR1Y2VkIGNoaWxkIHBhcnRpdGlvbiBsb2Nr aW5nIGFzIHdlbGwuDQoNCkkgZGlkIG5vdCByZXZpZXcgdGhlIGJyb2FkZXIgcGxhbmNhY2hlIHJl ZmFjdG9yaW5nIGRlc2lnbiwgZGlkIG5vdCBydW4NCmluc3RhbGxjaGVjay13b3JsZCwgYW5kIGRp ZCBub3QgdGVzdCBjb25jdXJyZW50IERETCBmcm9tIGEgc2VwYXJhdGUgc2Vzc2lvbi4NCg0KUmVn YXJkcywNCklsbWFyIFl1bnVzb3YKClRoZSBuZXcgc3RhdHVzIG9mIHRoaXMgcGF0Y2ggaXM6IFdh aXRpbmcgb24gQXV0aG9yCg==