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 1tptHI-00Dnwn-Q7 for pgsql-bugs@arkaria.postgresql.org; Wed, 05 Mar 2025 18:15:33 +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 1tptHG-0016Mf-EA for pgsql-bugs@arkaria.postgresql.org; Wed, 05 Mar 2025 18:15:30 +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 1tpssi-000ONe-0t for pgsql-bugs@lists.postgresql.org; Wed, 05 Mar 2025 17:50:08 +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 1tpssf-0019CP-1T for pgsql-bugs@lists.postgresql.org; Wed, 05 Mar 2025 17:50:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=B3wfs1OlkEzUsKVIPZk6toE51CcPgDgzpGYUYWOSbEU=; b=M/ziaZJrkPmh9u7OJyLkfYZrF/ ZBQU/K/5XYVTm6SUWuaTLKi9086FG9v+ElhYP5SmxYik+EUjlZZEcYNUy4XP9GPJZ+k+Pum2WOwY9 DKwXHQrntDb5QlsoyCIjGO1bCU/JDYpMHj5uJ+QfGyPRa3f9S4dq2lYSlpDHbhUiI4OQ0gKgv1Tur fhk0FPrBqa43AUXEIx521FmT0aUl1KLWDT/qWiMXVxhFD7s2QNqqg4/G8qKoVDqlfnKlLVDMqzXGw ei6ypgUSqut70Cq3z1ksNZmYDpZI0UpY/V3BjXlznvU8vsvclQ3kPHD4pUGgW2MNagMaiphwfTUjo mGpadxHg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tpsse-002w6m-RR for pgsql-bugs@lists.postgresql.org; Wed, 05 Mar 2025 17:50:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tpssd-0078s2-7x for pgsql-bugs@lists.postgresql.org; Wed, 05 Mar 2025 17:50:02 +0000 Content-Type: multipart/mixed; boundary="===============0946842168980423288==" MIME-Version: 1.0 Subject: BUG #18831: Particular queries using gin-indexes are not interruptible, resulting is resource usage concerns. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: niek.brasa@hitachienergy.com Reply-To: niek.brasa@hitachienergy.com, pgsql-bugs@lists.postgresql.org Date: Wed, 05 Mar 2025 17:49:38 +0000 Message-ID: <18831-e845ac44ebc5dd36@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0946842168980423288== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODgzMQpMb2dnZWQgYnk6ICAgICAgICAgIE5pZWsKRW1haWwgYWRkcmVz czogICAgICBuaWVrLmJyYXNhQGhpdGFjaGllbmVyZ3kuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTcuNApPcGVyYXRpbmcgc3lzdGVtOiAgIFdpbmRvd3MvTGludXgKRGVzY3JpcHRpb246ICAgICAg ICAKCkFzIHBhcnQgb2YgY2hlY2tpbmcgd2h5IHNvbWUgb2YgdGhlIHF1ZXJpZXMgd2VyZSBub3Qg aW50ZXJydXB0aWJsZSAoZXZlbgp0aG91Z2ggc3RhdGVtZW50X3RpbWVvdXQgd2FzIHNldCksIEkg d2FzIGFibGUgdG8gcmVkdWNlIGl0IHRvIHNvbWV0aGluZwpnZW5lcmljLCBhcyB0aGUgdXNhZ2Ug b2YgYSBnaW4gaW5kZXggYW5kIHRoZSA/fCBvcGVyYXRvci4gDQpJIGhhdmUgdGVzdGVkIHRoaXMg aW4gUG9zdGdyZVNRTCAxMy4yMCwgMTYuNCBhbmQgMTcuNA0KDQpBbHRob3VnaCBwZXJmb3JtYW5j ZSBpcyBjZXJ0YWlubHkgYSByZWFsIGlzc3VlIGFzIHdlbGwsIHRoYXQgaXMgbm90IHRoZSBtYWlu CmNhdXNlIG9mIGZpbGluZyBhIGJ1ZyByZXBvcnQuIEFzIHlvdSBjYW4gaW1hZ2luZSwgaXQgaXMg cmVsYXRpdmVseSBlYXN5IHRvCmV4ZWN1dGUgbXVsdGlwbGUgb2YgdGhvc2Ugc3RhdGVtZW50cywg YW5kIHB1dCB0aGUgc2VydmVyIHRvIGEgaGFsdCwgd2hpY2ggaXMKd2hhdCBoYXBwZW5lZCBpbiBv dXIgY2FzZS4gV2UgaGF2ZSAxMjAgc2Vjb25kcyBmb3Igc3RhdGVtZW50IHRpbWVvdXQsIGFuZCBp dAp3YXMgbm90IGJlaW5nIGhvbm9yZWQgY2F1c2luZyBvdXIgc2VydmljZXMgdG8gcmVjb25uZWN0 IGFmdGVyIGFub3RoZXIKdGltZW91dCB3YXMgdHJpZ2dlcmVkLCBjcmVhdGVkIGFub3RoZXIgY29u bmVjdGlvbiBhbmQgZXhlY3V0aW5nIHRoZSBzYW1lCnF1ZXJ5LiANCg0KT3V0cHV0IGZvciAxMDAw IGl0ZXJhdGlvbjoNCg0KTk9USUNFOiAgUXVlcnkgZm9yICAxMDAwLyAgICAgMTAgdG9vayAgICAg IDAuMDAxMDA0IHMNCk5PVElDRTogIFF1ZXJ5IGZvciAgMTAwMC8gICAgMTAwIHRvb2sgICAgICAw LjAwMDk4MyBzDQpOT1RJQ0U6ICBRdWVyeSBmb3IgIDEwMDAvICAgMTAwMCB0b29rICAgICAgMC4w MjkzNjEgcw0KTk9USUNFOiAgUXVlcnkgZm9yICAxMDAwLyAgMTAwMDAgdG9vayAgICAgIDMuMzY0 MDE4IHMNCk5PVElDRTogIFF1ZXJ5IGZvciAgMTAwMC8gIDUwMDAwIHRvb2sgICAgIDg0LjEwMTc5 MCBzDQpOT1RJQ0U6ICBRdWVyeSBmb3IgIDEwMDAvIDEwMDAwMCB0b29rICAgIDM3My43NjExNTgg cw0KTk9USUNFOiAgUXVlcnkgZm9yICAxMDAwLyAxNTAwMDAgdG9vayAgICA4NDYuNDI4MTEzIHMN Ck5PVElDRTogIFF1ZXJ5IGZvciAgMTAwMC8gMjAwMDAwIHRvb2sgICAxNDg2LjA4NTUzOCBzDQpO T1RJQ0U6ICBRdWVyeSBmb3IgIDEwMDAvIDMwMDAwMCB0b29rICAgMzM4Mi4wNDI0MzQgcw0KTk9U SUNFOiAgUXVlcnkgZm9yICAxMDAwLyA0MDAwMDAgdG9vayAgIDYyNDkuOTM0MTQ5IHMNCk5PVElD RTogIFF1ZXJ5IGZvciAgMTAwMC8gNTAwMDAwIHRvb2sgICA5NzMxLjYwNzk4MiBzDQpOT1RJQ0U6 ICBRdWVyeSBmb3IgIDEwMDAvIDYwMDAwMCB0b29rICAxNDExMy4zODI5MTcgcw0KTk9USUNFOiAg UXVlcnkgZm9yICAxMDAwLyA3MDAwMDAgdG9vayAgMTkyNzYuOTM0NzEyIHMNCk5PVElDRTogIFF1 ZXJ5IGZvciAgMTAwMC8gODAwMDAwIHRvb2sgIDI0OTkxLjEzODU1OCBzDQoNCkFuZCBvbmUgZm9y IDEwMDAgYW5kIGludGVycnVwdGVkICBhdCB0aGUgNTAwMDAgcG9pbnQgKHlvdSB3aWxsIG5vdGlj ZSwgaXQKd2lsbCByZXR1cm4gYWZ0ZXIgdGhlIHF1ZXJ5IGlzIGV4ZWN1dGVkIHdpdGggZXhjZXB0 aW9uKQ0KDQpOT1RJQ0U6ICBRdWVyeSBmb3IgIDEwMDAvICA1MDAwMCB0b29rICAgICA5My4zNjIw NjYgcywgYmVmb3JlIGJlaW5nCmNhbmNlbGVkLg0KDQpCZWxvdyB5b3UgZmluZCB0aGUgcmVwcm9k dWNpYmxlIGJsb2NrLCBsZXQgaXQgcnVuLCB3aGVuIHlvdSBzZWUgdGhhdCB5b3UKaGF2ZSB0byB3 YWl0IGEgbG9uZyB0aW1lIGZvciBhIHJlc3VsdCwgdXNlIHRoZSBwZ190ZXJtaW5hdGVfYmFja2Vu ZCBvcgpwZ19jYW5jZWxfYmFja2VuZCB0byBzdG9wIHRoZSBzdGF0ZW1lbnQuIFlvdSB3aWxsIG5v dGljZSB0aGF0IG5vdGhpbmcgaXMKaGFwcGVuaW5nLCBidXQgdGhlIHN0YXRlbWVudCBpcyBhY3R1 YWxseSBleGVjdXRlZCwgeW91IHdpbGwgZ2V0IGEKcXVlcnlfY2FuY2VsZWQgZXhjZXB0aW9uLg0K DQpETw0KJCQNCkRFQ0xBUkUNCiAgX2R1bW15IGludDsNCiAgX3N0YXJ0IHRpbWVzdGFtcDsNCiAg X2FfdCAgIGludFtdIDo9IEFSUkFZWzEsMTAsMTAwLDEwMDAsMTAwMDAsMTAwMDAwXTsNCiAgX2Ff bCAgIGludFtdIDo9CkFSUkFZWzEwLDEwMCwxMDAwLDEwMDAwLDUwMDAwLDEwMDAwMCwxNTAwMDAs MjAwMDAwLDMwMDAwMCw0MDAwMDAsNTAwMDAwLDYwMDAwMCw3MDAwMDAsODAwMDAwLDkwMDAwMCwx MDAwMDAwXTsNCiAgX2lfbCAgIGludDsNCiAgX2lfdCAgIGludDsNCkJFR0lODQogICAgRk9SRUFD SCBfaV90IElOIEFSUkFZIF9hX3QNCglMT09QDQoJICAgIC0tIGNyZWF0ZSBhIHRhYmxlIHdpdGgg X2lfdCByb3dzIHRoYXQgY29udGFpbnMgYSBqc29uYiBjb2x1bW4gJ2RvYycsCndpdGgNCgkJLS0g b25lIGF0dHJpYnV0ZSAnYScgY29udGFpbmluZyBhbiBhcnJheSBvZiB0d28gcmFuZG9tIHV1aWRz IGFzIHRleHQuDQoJCS0tIHVzaW5nIHRoZSBnaW4gaW5kZXggaGVyZSwgd2lsbCBjYXVzZSB0aGUg c3RhdGVtZW50IHRvIGJlIG5vbgppbnRlcnJ1cHRpYmxlDQoJCURST1AgVEFCTEUgSUYgRVhJU1RT IHB1YmxpYy50MTsNCgkJQ1JFQVRFIFRBQkxFIHB1YmxpYy50MSBhcyAoU0VMRUNUIGpzb25iX2J1 aWxkX29iamVjdCgnYScsCmpzb25iX2J1aWxkX2FycmF5KGdlbl9yYW5kb21fdXVpZCgpOjp0ZXh0 LGdlbl9yYW5kb21fdXVpZCgpOjp0ZXh0KSkgZG9jIEZST00KZ2VuZXJhdGVfc2VyaWVzKDEsX2lf dCkpOw0KCQlDUkVBVEUgSU5ERVggdDFfaWR4IE9OIHB1YmxpYy50MSBVU0lORyBnaW4gKChkb2Mt PidhJykganNvbmJfb3BzKTsNCgkJQU5BTFlaRSBwdWJsaWMudDE7DQoJDQoJICAgIEZPUkVBQ0gg X2lfbCBJTiBBUlJBWSBfYV9sDQoJCUxPT1ANCgkJICBCRUdJTg0KCQkJX3N0YXJ0IDo9IGNsb2Nr X3RpbWVzdGFtcCgpOw0KCQkJDQoJCQktLSB0aGUgZm9sbG93aW5nIHF1ZXJ5IGNhbm5vdCBiZSBj YW5jZWxsZWQgb3IgdGVybWluYXRlZCBhbmQgdGhlIHBvc3RncmVzCnByb2Nlc3MNCgkJCS0tIHdp bGwga2VlcCBydW5uaW5nLCBjYW4gb25seSBoYXJkIGtpbGwgdGhlIHByb2Nlc3MsIHdoaWNoIGNh dXNlcyB0aGUKZGF0YWJhc2UgdG8gZ28NCgkJCS0tIGludG8gcmVjb3ZlcnkgbW9kZS4gSWYgc3Rh dGVtZW50IHRha2VzIGxvbmdlciB0aGFuIHRoZSBzdGF0ZW1lbnQKdGltZW91dCwgaXQgd2lsbA0K CQkJLS0gcmV0dXJuIHdpdGggY2FuY2VsZWQgc3RhdGVtZW50IGV4Y2VwdGlvbi4NCgkJCS0tIEFs dGhvdWdoIHBlcmZvcm1hbmNlIGlzIGhvcnJlbmRvdXMgd2l0aCBsYXJnZXIgdGFibGUgY29udGVu dHMsIHRoZQpmYWN0IHRoYXQgaXQgaXMNCgkJCS0tIG5vdCBpbnRlcnJ1cHRpYmxlIGlzIHRoZSBt YWluIGNvbmNlcm4gcmFpc2VkIGhlcmUuDQoJCQktLQ0KCQkJLS0gIC0gVXNpbmcgYW4gaW4gbWVt b3J5IHRhYmxlLCB3aWxsIGNhdXNlIHRoZSBzdGF0ZW1lbnQgdG8gYmUKaW50ZXJydXB0aWJsZS4N CgkJCS0tICAgICx0MSBBUyAoc2VsZWN0IGpzb25iX2J1aWxkX29iamVjdCgnYScsCmpzb25iX2J1 aWxkX2FycmF5KGdlbl9yYW5kb21fdXVpZCgpOjp0ZXh0LGdlbl9yYW5kb21fdXVpZCgpOjp0ZXh0 KSkgZG9jIEZST00KZ2VuZXJhdGVfc2VyaWVzKDEsX2lfdCkpDQoJCQktLSAgLSBVc2luZyBhbiBh Y3R1YWwgdGFibGUgd2l0aG91dCB0aGUgZ2luIGluZGV4LCB3aWxsIGNhdXNlIHRoZQpzdGF0ZW1l bnQgdG8gYmUNCgkJCS0tICAgIGludGVycnVwdGlibGUNCgkJCS0tICAtIFVzaW5nIGEgZ2luIGlu ZGV4LCB3aWxsIGNhdXNlIHRoZSBzdGF0ZW1ldG50IHRvIGJlIG5vbgppbnRlcnJ1cHRpYmxlLg0K CQkJLS0NCgkJCVdJVEggbDEgQVMgKHNlbGVjdCBnZW5fcmFuZG9tX3V1aWQoKTo6dGV4dCB1dWlk IEZST00KZ2VuZXJhdGVfc2VyaWVzKDEsX2lfbCkpDQoJCQlTRUxFQ1QgMSBJTlRPIF9kdW1teQ0K CQkJICBGUk9NIHQxDQoJCQkgV0hFUkUgdDEuZG9jLT4nYScgP3wgKFNFTEVDVCBhcnJheV9hZ2co dXVpZCkgRlJPTSBsMSk7DQoJCSAgRVhDRVBUSU9OIFdIRU4gcXVlcnlfY2FuY2VsZWQgVEhFTgkJ ICANCgkJICAgIFJBSVNFIE5PVElDRSAnUXVlcnkgZm9yICUvJSB0b29rICUgcywgYmVmb3JlIGJl aW5nIGNhbmNlbGVkLicNCgkJCSAgICAgICAgICAgICxMUEFEKF9pX3Q6OnRleHQsNSwnICcpDQoJ CQkJCQksTFBBRChfaV9sOjp0ZXh0LDcsJyAnKQ0KCQkJCQkJLExQQUQoRVhUUkFDVChlcG9jaCBG Uk9NIChjbG9ja190aW1lc3RhbXAoKSAtIF9zdGFydCkpOjp0ZXh0LDEzLCcKJyk7DQoJCQlSRVRV Uk47DQoJCSAgRU5EOw0KCSAgICAgIFJBSVNFIE5PVElDRSAnUXVlcnkgZm9yICUvJSB0b29rICUg cycNCgkJICAgICAgICAgICAgICAsTFBBRChfaV90Ojp0ZXh0LDUsJyAnKQ0KCQkJCQkgICxMUEFE KF9pX2w6OnRleHQsNywnICcpDQoJCQkJCSAgLExQQUQoRVhUUkFDVChlcG9jaCBGUk9NIChjbG9j a190aW1lc3RhbXAoKSAtIF9zdGFydCkpOjp0ZXh0LDEzLCcKJyk7DQoJCUVORCBMT09QOw0KCUVO RCBMT09QOw0KRU5EOw0KJCQ7Cgo= --===============0946842168980423288==--