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 1tl1f7-008i68-Ea for pgsql-committers@arkaria.postgresql.org; Thu, 20 Feb 2025 08:12:01 +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 1tl1f5-002ypR-Vu for pgsql-committers@arkaria.postgresql.org; Thu, 20 Feb 2025 08:12:00 +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 1tl1f5-002ypJ-K0 for pgsql-committers@lists.postgresql.org; Thu, 20 Feb 2025 08:11:59 +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 1tl1f3-001rcs-0O for pgsql-committers@lists.postgresql.org; Thu, 20 Feb 2025 08:11:58 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=YMEjPhMo2HwjdtE6w/3O01U7CKPJ5vpCWuJ5Sc7So5Y=; b=z7QGtlnQq5zotx3h4W+VSXWCB4 M+yyTwtrWjk+an+OajDPtoOBa6Zl4HWclkrACjbaUc5CLlLV/0Oh7bQNURkC0VnPL0+k2+aNuR/03 0qRrMo7xW6LViaaIUM4JwlOcsjq7/T2R3NVnwAeV04bPZCpQnCSFfxVtpJFPv93sjJ890VSnK/KIv +dvFdksdD8Y8zb9yZvGQMhR/rb3LEojNUkAXkmfmWT9M1mu6nck+PE6tV6Ld1/5o92kAMMbKxxsWT AzlsGuFR2ZUEDhRL+TqOvu4nHxZou/kvSUB/CJ3PFd1EmsQCjeYnadvUD26aRyxg7+/+jJjcTWrJs 3z7Txw4g==; 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 1tl1f2-006d2v-I9 for pgsql-committers@lists.postgresql.org; Thu, 20 Feb 2025 08:11:56 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1tl1f3-000H54-0k for pgsql-committers@lists.postgresql.org; Thu, 20 Feb 2025 08:11:56 +0000 Content-Type: multipart/mixed; boundary="===============9178343188666849150==" MIME-Version: 1.0 From: Amit Langote To: pgsql-committers@lists.postgresql.org Subject: pgsql: Don't lock partitions pruned by initial pruning X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 20 Feb 2025 08:11:56 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============9178343188666849150== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RG9uJ3QgbG9jayBwYXJ0aXRpb25zIHBydW5lZCBieSBpbml0aWFsIHBydW5pbmcKCkJlZm9yZSBl eGVjdXRpbmcgYSBjYWNoZWQgZ2VuZXJpYyBwbGFuLCBBY3F1aXJlRXhlY3V0b3JMb2NrcygpIGlu CnBsYW5jYWNoZS5jIGxvY2tzIGFsbCByZWxhdGlvbnMgaW4gYSBwbGFuJ3MgcmFuZ2UgdGFibGUg dG8gZW5zdXJlIHRoZQpwbGFuIGlzIHNhZmUgZm9yIGV4ZWN1dGlvbi4gSG93ZXZlciwgdGhpcyBs b2NrcyBydW50aW1lLXBydW5hYmxlCnJlbGF0aW9ucyB0aGF0IHdpbGwgbGF0ZXIgYmUgcHJ1bmVk IGR1cmluZyAiaW5pdGlhbCIgcnVudGltZSBwcnVuaW5nLAppbnRyb2R1Y2luZyB1bm5lY2Vzc2Fy eSBvdmVyaGVhZC4KClRoaXMgY29tbWl0IGRlZmVycyBsb2NraW5nIGZvciBzdWNoIHJlbGF0aW9u cyB0byBleGVjdXRvciBzdGFydHVwIGFuZAplbnN1cmVzIHRoYXQgaWYgdGhlIENhY2hlZFBsYW4g aXMgaW52YWxpZGF0ZWQgZHVlIHRvIGNvbmN1cnJlbnQgRERMCmR1cmluZyB0aGlzIHdpbmRvdywg cmVwbGFubmluZyBpcyB0cmlnZ2VyZWQuIERlZmVycmluZyB0aGVzZSBsb2Nrcwphdm9pZHMgdW5u ZWNlc3NhcnkgbG9ja2luZyBvdmVyaGVhZCBmb3IgcHJ1bmVkIHBhcnRpdGlvbnMsIHJlc3VsdGlu ZwppbiBzaWduaWZpY2FudCBzcGVlZHVwLCBwYXJ0aWN1bGFybHkgd2hlbiBtYW55IHBhcnRpdGlv bnMgYXJlIHBydW5lZApkdXJpbmcgaW5pdGlhbCBydW50aW1lIHBydW5pbmcuCgoqIENoYW5nZXMg dG8gbG9ja2luZyB3aGVuIGV4ZWN1dGluZyBnZW5lcmljIHBsYW5zOgoKQWNxdWlyZUV4ZWN1dG9y TG9ja3MoKSBub3cgbG9ja3Mgb25seSB1bnBydW5hYmxlIHJlbGF0aW9ucywgdGhhdCBpcywKdGhv c2UgZm91bmQgaW4gUGxhbm5lZFN0bXQudW5wcnVuYWJsZVJlbGlkcyAoaW50cm9kdWNlZCBpbiBj b21taXQKY2JjMTI3OTE3ZSksIHRvIGF2b2lkIGxvY2tpbmcgcnVudGltZS1wcnVuYWJsZSBwYXJ0 aXRpb25zCnVubmVjZXNzYXJpbHkuICBUaGUgcmVtYWluaW5nIGxvY2tzIGFyZSB0YWtlbiBieQpF eGVjRG9Jbml0aWFsUHJ1bmluZygpLCB3aGljaCBhY3F1aXJlcyB0aGVtIG9ubHkgZm9yIHBhcnRp dGlvbnMgdGhhdApzdXJ2aXZlIHBydW5pbmcuCgpUaGlzIGRlZmVycmFsIGRvZXMgbm90IGFmZmVj dCB0aGUgbG9ja3MgcmVxdWlyZWQgZm9yIHBlcm1pc3Npb24KY2hlY2tpbmcgaW4gSW5pdFBsYW4o KSwgd2hpY2ggdGFrZXMgcGxhY2UgYmVmb3JlIGluaXRpYWwgcHJ1bmluZy4KRXhlY0NoZWNrUGVy bWlzc2lvbnMoKSBub3cgaW5jbHVkZXMgYW4gQXNzZXJ0IHRvIHZlcmlmeSB0aGF0IGFsbApyZWxh dGlvbnMgdW5kZXJnb2luZyBwZXJtaXNzaW9uIGNoZWNrcywgbm9uZSBvZiB3aGljaCBjYW4gYmUg aW4gdGhlCnNldCBvZiBydW50aW1lLXBydW5hYmxlIHJlbGF0aW9ucywgYXJlIHByb3Blcmx5IGxv Y2tlZC4KCiogUGxhbiBpbnZhbGlkYXRpb24gaGFuZGxpbmc6CgpEZWZlcnJpbmcgbG9ja3MgaW50 cm9kdWNlcyBhIHdpbmRvdyB3aGVyZSBwcnVuYWJsZSByZWxhdGlvbnMgbWF5IGJlCmFsdGVyZWQg YnkgY29uY3VycmVudCBEREwsIGludmFsaWRhdGluZyB0aGUgcGxhbi4gQSBuZXcgZnVuY3Rpb24s CkV4ZWN1dG9yU3RhcnRDYWNoZWRQbGFuKCksIHdyYXBzIEV4ZWN1dG9yU3RhcnQoKSB0byBkZXRl Y3QgYW5kIGhhbmRsZQppbnZhbGlkYXRpb24gY2F1c2VkIGJ5IGRlZmVycmVkIGxvY2tpbmcuIElm IGludmFsaWRhdGlvbiBvY2N1cnMsCkV4ZWN1dG9yU3RhcnRDYWNoZWRQbGFuKCkgdXBkYXRlcyBD YWNoZWRQbGFuIHVzaW5nIHRoZSBuZXcKVXBkYXRlQ2FjaGVkUGxhbigpIGZ1bmN0aW9uIGFuZCBy ZXRyaWVzIGV4ZWN1dGlvbiB3aXRoIHRoZSB1cGRhdGVkCnBsYW4uIFRvIGVuc3VyZSBhbGwgY29k ZSBwYXRocyB0aGF0IG1heSBiZSBhZmZlY3RlZCBieSB0aGlzIGhhbmRsZQppbnZhbGlkYXRpb24g cHJvcGVybHksIGFsbCBjYWxsZXJzIG9mIEV4ZWN1dG9yU3RhcnQgdGhhdCBtYXkgZXhlY3V0ZSBh ClBsYW5uZWRTdG10IGZyb20gYSBDYWNoZWRQbGFuIGhhdmUgYmVlbiB1cGRhdGVkIHRvIHVzZQpF eGVjdXRvclN0YXJ0Q2FjaGVkUGxhbigpIGluc3RlYWQuCgpVcGRhdGVDYWNoZWRQbGFuKCkgcmVw bGFjZXMgc3RhbGUgcGxhbnMgaW4gQ2FjaGVkUGxhbi5zdG10X2xpc3QuIEEgbmV3CkNhY2hlZFBs YW4uc3RtdF9jb250ZXh0LCBjcmVhdGVkIGFzIGEgY2hpbGQgb2YgQ2FjaGVkUGxhbi5jb250ZXh0 LAphbGxvd3MgZnJlZWluZyBvbGQgUGxhbm5lZFN0bXRzIHdoaWxlIHByZXNlcnZpbmcgdGhlIENh Y2hlZFBsYW4Kc3RydWN0dXJlIGFuZCBpdHMgc3RhdGVtZW50IGxpc3QuIFRoaXMgZW5zdXJlcyB0 aGF0IGxvb3BzIG92ZXIKc3RhdGVtZW50cyBpbiB1cHN0cmVhbSBjYWxsZXJzIG9mIEV4ZWN1dG9y U3RhcnRDYWNoZWRQbGFuKCkgcmVtYWluCmludGFjdC4KCkV4ZWN1dG9yU3RhcnQoKSBhbmQgRXhl Y3V0b3JTdGFydF9ob29rIGltcGxlbWVudGF0aW9ucyBub3cgcmV0dXJuIGEKYm9vbGVhbiB2YWx1 ZSBpbmRpY2F0aW5nIHdoZXRoZXIgcGxhbiBpbml0aWFsaXphdGlvbiBzdWNjZWVkZWQgd2l0aCBh CnZhbGlkIFBsYW5TdGF0ZSB0cmVlIGluIFF1ZXJ5RGVzYy5wbGFuc3RhdGUsIG9yIGZhbHNlIG90 aGVyd2lzZSwgaW4Kd2hpY2ggY2FzZSBRdWVyeURlc2MucGxhbnN0YXRlIGlzIE5VTEwuIEhvb2sg aW1wbGVtZW50YXRpb25zIGFyZQpyZXF1aXJlZCB0byBjYWxsIHN0YW5kYXJkX0V4ZWN1dG9yU3Rh cnQoKSBhdCB0aGUgYmVnaW5uaW5nLCBhbmQgaWYgaXQKcmV0dXJucyBmYWxzZSwgdGhleSBzaG91 bGQgZG8gdGhlIHNhbWUgd2l0aG91dCBwcm9jZWVkaW5nLgoKKiBUZXN0aW5nOgoKVG8gdmVyaWZ5 IHRoZXNlIGNoYW5nZXMsIHRoZSBkZWxheV9leGVjdXRpb24gbW9kdWxlIHRlc3RzIHNjZW5hcmlv cwp3aGVyZSBjYWNoZWQgcGxhbnMgYmVjb21lIGludmFsaWQgZHVlIHRvIGNoYW5nZXMgaW4gcHJ1 bmFibGUgcmVsYXRpb25zCmFmdGVyIGRlZmVycmVkIGxvY2tzLgoKKiBOb3RlIHRvIGV4dGVuc2lv biBhdXRob3JzOgoKRXhlY3V0b3JTdGFydF9ob29rIGltcGxlbWVudGF0aW9ucyBtdXN0IHZlcmlm eSBwbGFuIHZhbGlkaXR5IGFmdGVyCmNhbGxpbmcgc3RhbmRhcmRfRXhlY3V0b3JTdGFydCgpLCBh cyBleHBsYWluZWQgZWFybGllci4gRm9yIGV4YW1wbGU6CgogICAgaWYgKHByZXZfRXhlY3V0b3JT dGFydCkKICAgICAgICBwbGFuX3ZhbGlkID0gcHJldl9FeGVjdXRvclN0YXJ0KHF1ZXJ5RGVzYywg ZWZsYWdzKTsKICAgIGVsc2UKICAgICAgICBwbGFuX3ZhbGlkID0gc3RhbmRhcmRfRXhlY3V0b3JT dGFydChxdWVyeURlc2MsIGVmbGFncyk7CgogICAgaWYgKCFwbGFuX3ZhbGlkKQogICAgICAgIHJl dHVybiBmYWxzZTsKCiAgICA8ZXh0ZW5zaW9uLWNvZGU+CgogICAgcmV0dXJuIHRydWU7CgpFeHRl bnNpb25zIGFjY2Vzc2luZyBjaGlsZCByZWxhdGlvbnMsIGVzcGVjaWFsbHkgcHJ1bmFibGUgcGFy dGl0aW9ucywKdmlhIEV4ZWNHZXRSYW5nZVRhYmxlUmVsYXRpb24oKSBtdXN0IG5vdyBlbnN1cmUg dGhlaXIgUlQgaW5kZXhlcyBhcmUKcHJlc2VudCBpbiBlc191bnBydW5lZF9yZWxpZHMgKGludHJv ZHVjZWQgaW4gY29tbWl0IGNiYzEyNzkxN2UpLCBvcgp0aGV5IHdpbGwgZW5jb3VudGVyIGFuIGVy cm9yLiBUaGlzIGlzIGEgc3RyaWN0IHJlcXVpcmVtZW50IGFmdGVyIHRoaXMKY2hhbmdlLCBhcyBv bmx5IHJlbGF0aW9ucyBpbiB0aGF0IHNldCBhcmUgbG9ja2VkLgoKVGhlIGlkZWEgb2YgZGVmZXJy aW5nIHNvbWUgbG9ja3MgdG8gZXhlY3V0b3Igc3RhcnR1cCwgYWxsb3dpbmcgbG9ja3MKZm9yIHBy dW5hYmxlIHBhcnRpdGlvbnMgdG8gYmUgc2tpcHBlZCwgd2FzIGZpcnN0IHByb3Bvc2VkIGJ5IFRv bSBMYW5lLgoKUmV2aWV3ZWQtYnk6IFJvYmVydCBIYWFzIDxyb2JlcnRtaGFhc0BnbWFpbC5jb20+ IChlYXJsaWVyIHZlcnNpb25zKQpSZXZpZXdlZC1ieTogRGF2aWQgUm93bGV5IDxkZ3Jvd2xleW1s QGdtYWlsLmNvbT4gKGVhcmxpZXIgdmVyc2lvbnMpClJldmlld2VkLWJ5OiBUb20gTGFuZSA8dGds QHNzcy5wZ2gucGEudXM+IChlYXJsaWVyIHZlcnNpb25zKQpSZXZpZXdlZC1ieTogVG9tYXMgVm9u ZHJhIDx0b21hc0B2b25kcmEubWU+ClJldmlld2VkLWJ5OiBKdW53YW5nIFpoYW8gPHpoandwa3VA Z21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBK0hpd3FGR2tNU2dl NlRnQzlLUXpkZTBvaHBBeWNMUXVWN29vaXRFRXBiS0IwT19tZ0BtYWlsLmdtYWlsLmNvbQoKQnJh bmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3Fs Lm9yZy9wZy9jb21taXRkaWZmLzUyNTM5MmQ1NzI3ZjQ2OWU5YTU4ODJlMWQ3Mjg5MTdhNGJlNTYx NDcKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmNvbnRyaWIvYXV0b19leHBsYWluL2F1 dG9fZXhwbGFpbi5jICAgICAgICAgICAgICAgIHwgIDE2ICstCmNvbnRyaWIvcGdfc3RhdF9zdGF0 ZW1lbnRzL3BnX3N0YXRfc3RhdGVtZW50cy5jICAgIHwgIDE2ICstCnNyYy9iYWNrZW5kL2NvbW1h bmRzL2NvcHl0by5jICAgICAgICAgICAgICAgICAgICAgIHwgICA1ICstCnNyYy9iYWNrZW5kL2Nv bW1hbmRzL2NyZWF0ZWFzLmMgICAgICAgICAgICAgICAgICAgIHwgICA1ICstCnNyYy9iYWNrZW5k L2NvbW1hbmRzL2V4cGxhaW4uYyAgICAgICAgICAgICAgICAgICAgIHwgIDIyICstCnNyYy9iYWNr ZW5kL2NvbW1hbmRzL2V4dGVuc2lvbi5jICAgICAgICAgICAgICAgICAgIHwgICA0ICstCnNyYy9i YWNrZW5kL2NvbW1hbmRzL21hdHZpZXcuYyAgICAgICAgICAgICAgICAgICAgIHwgICA1ICstCnNy Yy9iYWNrZW5kL2NvbW1hbmRzL3BvcnRhbGNtZHMuYyAgICAgICAgICAgICAgICAgIHwgICAxICsK c3JjL2JhY2tlbmQvY29tbWFuZHMvcHJlcGFyZS5jICAgICAgICAgICAgICAgICAgICAgfCAgIDkg Ky0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvdHJpZ2dlci5jICAgICAgICAgICAgICAgICAgICAgfCAg MTUgKysKc3JjL2JhY2tlbmQvZXhlY3V0b3IvUkVBRE1FICAgICAgICAgICAgICAgICAgICAgICAg fCAgMzUgKystCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNNYWluLmMgICAgICAgICAgICAgICAg ICAgIHwgMTI3ICsrKysrKysrKystCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNQYXJhbGxlbC5j ICAgICAgICAgICAgICAgIHwgIDEyICstCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNQYXJ0aXRp b24uYyAgICAgICAgICAgICAgIHwgIDM4ICsrKy0Kc3JjL2JhY2tlbmQvZXhlY3V0b3IvZXhlY1V0 aWxzLmMgICAgICAgICAgICAgICAgICAgfCAgIDggKwpzcmMvYmFja2VuZC9leGVjdXRvci9mdW5j dGlvbnMuYyAgICAgICAgICAgICAgICAgICB8ICAgNCArLQpzcmMvYmFja2VuZC9leGVjdXRvci9z cGkuYyAgICAgICAgICAgICAgICAgICAgICAgICB8ICAyOSArKy0Kc3JjL2JhY2tlbmQvdGNvcC9w b3N0Z3Jlcy5jICAgICAgICAgICAgICAgICAgICAgICAgfCAgIDQgKy0Kc3JjL2JhY2tlbmQvdGNv cC9wcXVlcnkuYyAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgNTEgKysrKy0Kc3JjL2JhY2tl bmQvdXRpbHMvY2FjaGUvcGxhbmNhY2hlLmMgICAgICAgICAgICAgICAgfCAxOTcgKysrKysrKysr KysrKy0tLQpzcmMvYmFja2VuZC91dGlscy9tbWdyL3BvcnRhbG1lbS5jICAgICAgICAgICAgICAg ICB8ICAgNCArLQpzcmMvaW5jbHVkZS9jb21tYW5kcy9leHBsYWluLmggICAgICAgICAgICAgICAg ICAgICB8ICAgNiArLQpzcmMvaW5jbHVkZS9jb21tYW5kcy90cmlnZ2VyLmggICAgICAgICAgICAg ICAgICAgICB8ICAgMSArCnNyYy9pbmNsdWRlL2V4ZWN1dG9yL2V4ZWNkZXNjLmggICAgICAgICAg ICAgICAgICAgIHwgICAyICsKc3JjL2luY2x1ZGUvZXhlY3V0b3IvZXhlY3V0b3IuaCAgICAgICAg ICAgICAgICAgICAgfCAgMzQgKystCnNyYy9pbmNsdWRlL25vZGVzL2V4ZWNub2Rlcy5oICAgICAg ICAgICAgICAgICAgICAgIHwgICAzICsKc3JjL2luY2x1ZGUvdXRpbHMvcGxhbmNhY2hlLmggICAg ICAgICAgICAgICAgICAgICAgfCAgNDYgKysrLQpzcmMvaW5jbHVkZS91dGlscy9wb3J0YWwuaCAg ICAgICAgICAgICAgICAgICAgICAgICB8ICAgNCArLQpzcmMvdGVzdC9tb2R1bGVzL2RlbGF5X2V4 ZWN1dGlvbi9NYWtlZmlsZSAgICAgICAgICB8ICAgMyArLQpzcmMvdGVzdC9tb2R1bGVzL2RlbGF5 X2V4ZWN1dGlvbi9kZWxheV9leGVjdXRpb24uYyB8ICA2NiArKysrKy0KLi4uL2RlbGF5X2V4ZWN1 dGlvbi9leHBlY3RlZC9jYWNoZWQtcGxhbi1pbnZhbC5vdXQgfCAyNTAgKysrKysrKysrKysrKysr KysrKysrCnNyYy90ZXN0L21vZHVsZXMvZGVsYXlfZXhlY3V0aW9uL21lc29uLmJ1aWxkICAgICAg IHwgICAxICsKLi4uL2RlbGF5X2V4ZWN1dGlvbi9zcGVjcy9jYWNoZWQtcGxhbi1pbnZhbC5zcGVj ICAgfCAgODYgKysrKysrKwozMyBmaWxlcyBjaGFuZ2VkLCAxMDE0IGluc2VydGlvbnMoKyksIDk1 IGRlbGV0aW9ucygtKQoK --===============9178343188666849150==--