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 1lXUPi-0007hL-EV for pgsql-bugs@arkaria.postgresql.org; Fri, 16 Apr 2021 19:46:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lXUPh-0007L9-DI for pgsql-bugs@arkaria.postgresql.org; Fri, 16 Apr 2021 19:46:01 +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 1lXRiQ-0000d7-9P for pgsql-bugs@lists.postgresql.org; Fri, 16 Apr 2021 16:53:10 +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 1lXRiK-0006CF-Qz for pgsql-bugs@lists.postgresql.org; Fri, 16 Apr 2021 16:53:08 +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=iBLlKRbLf3NNPS61eHmNTbUUI7C5P1u7HXZoDn3qlE4=; b=IA1gD/5AZFmEnpdXOtybMQn2q5 r49LBVGPSOCP7JUzq1ca0rvzlMYShMvaGgkyuIvSTZ92Dcy28j+pOaGZIh7XaAPIREgZUXL/Vy7z/ Dr4leKhckGsbvtst23NqH8WPxE2FeXU0x8IiH3ntmWyePq2UaX32dvJ/ZEzearQVYn8p4H005Pjp5 yfZLQb6MV5MNqlltGh4NU10EQOwgcSNa/6vSFSlc/smI3YFXGfBKmekxCjNjb5nDW65eSP4pqYmWU P4s9jVOczmMf5JKznaPMOdWHhKZWoH3WWMqhO2WO35rsv3QrWR4RDiZdfMH4Jj5q0EgbWH59Cm5Sh DoqXmQuw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lXRiJ-0005w5-AC for pgsql-bugs@lists.postgresql.org; Fri, 16 Apr 2021 16:53:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lXRiI-0003CW-4r for pgsql-bugs@lists.postgresql.org; Fri, 16 Apr 2021 16:53:02 +0000 Content-Type: multipart/mixed; boundary="===============6878469488364843180==" MIME-Version: 1.0 Subject: BUG #16967: Extremely slow update statement in trigger To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: postgres@burri.li Reply-To: postgres@burri.li, pgsql-bugs@lists.postgresql.org Date: Fri, 16 Apr 2021 16:52:15 +0000 Message-ID: <16967-39db5f50df41173a@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 --===============6878469488364843180== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjk2NwpMb2dnZWQgYnk6ICAgICAgICAgIE5pY29sYXMgQnVycmkKRW1h aWwgYWRkcmVzczogICAgICBwb3N0Z3Jlc0BidXJyaS5saQpQb3N0Z3JlU1FMIHZlcnNpb246IDEz LjIKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eCAmYW1wOyBXaW5kb3dzCkRlc2NyaXB0aW9uOiAg ICAgICAgCgpIaSwNCkR1cmluZyBhIGRhdGEgbWlncmF0aW9uIG91ciBwcm9kdWN0aW9uIHN5c3Rl bSBzcGVudCBzZXZlcmFsIGhvdXJzIGluIGEKc2ltcGxlIHVwZGF0ZSBzdGF0ZW1lbnQgb2YgYSB0 YWJsZSB3aXRoIHZlcnkgZmV3IGNvbHVtbnMgYW5kIGFib3V0IDIwMGsKcmVjb3Jkcy4gV2UgbWFu YWdlZCB0byByZXByb2R1Y2UgdGhlIHByb2JsZW0gYW5kIGEgbWluaW1hbCBzZXR1cCBmb3IKcmVw cm9kdWN0aW9uIGNhbiBiZSBmb3VuZCBoZXJlOg0KaHR0cHM6Ly93d3cuZHJvcGJveC5jb20vcy9t eGphdnBsNDNzNDhoZGcvYnVnX3JlcG9ydC5zcWwuIFRoZSBidWcgc2VlbXMgdG8KYmUgcmVsYXRl ZCB0byBxdWVyeSBwbGFuIGNhY2hpbmcgYW5kIGNhbiBiZSByZXByb2R1Y2VkIG9uIHBvc3RyZ3Jl cyAxMS4xMQphbmQgMTMuMiAoSSBoYXZlIG5vdCBydW4gdGVzdHMgd2l0aCBvdGhlciB2ZXJzaW9u cykNCg0KRGVzY3JpcHRpb246DQpXZSB1c2UgYSBzdGF0ZW1lbnQgbGV2ZWwgdHJpZ2dlciB0byBs b2cgY2hhbmdlcyB0byByZWNvcmRzIGluIGEgY2VydGFpbgp0YWJsZS4gT24gZXZlcnkgdXBkYXRl LCB0aGUgdHJpZ2dlciBjYWxscyBhIGZ1bmN0aW9uIGNvbXBhcmluZyDigJxvbGQgdGFibGXigJ0K YW5kIOKAnG5ldyB0YWJsZeKAnS4gRm9yIGV2ZXJ5IHJlY29yZCBjaGFuZ2VkIGJ5IHRoZSBzdGF0 ZW1lbnQsIHRoZSBmdW5jdGlvbgppbnNlcnRzIGEgbmV3IHJlY29yZCBpbiBhIOKAnGxvZ+KAnSB0 YWJsZS4gSW4gdGhlIGZvbGxvd2luZyBzY2VuYXJpbywgZXhlY3V0aW9uCnRpbWVzIGV4cGxvZGU6 DQpGaXJzdCwgZXhlY3V0ZSBhbiB1cGRhdGUgc3RhdGVtZW50IHRoYXQgYWZmZWN0cyBubyByb3dz LiBUaGlzIHF1ZXJ5IGlzIGZhc3QKYW5kIGNvbXBsZXRlcyB3aXRoaW4gbWlsbGlzZWNvbmRzLiBU aGVuLCBleGVjdXRlIGEgc2Vjb25kIHVwZGF0ZSBzdGF0ZW1lbnQKdGhhdCBhZmZlY3RzIGEgbG90 IG9mIHJlY29yZHMuIEF0IDIwMGsgcmVjb3JkcywgdGhpcyBxdWVyeSBydW5zIGZvciBtb3JlCnRo YW4gNGggb24gbXkgd29ya3N0YXRpb24uIElmIHdlIGNhbGwg4oCcZGlzY2FyZCBwbGFuc+KAnSBi ZWZvcmUgZXhlY3V0aW5nIHRoZQpzZWNvbmQgdXBkYXRlIHN0YXRlbWVudCwgb3IgaWYgd2UgZG8g bm90IGV4ZWN1dGUgdGhlIGZpcnN0IHN0YXRlbWVudCBhdCBhbGwsCnRoZSB1cGRhdGUgb2YgYWxs IHJvd3MgY29tcGxldGVzIHdpdGhpbiBhYm91dCAxIHNlY29uZC4NCg0KVGhhbmtzIGFuZCBiZXN0 IFJlZ2FyZHMNCk5pY29sYXMKCg== --===============6878469488364843180==--