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 1p3k5J-00030C-Aj for pgsql-bugs@arkaria.postgresql.org; Fri, 09 Dec 2022 20:35:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p3k5G-0000bN-Ad for pgsql-bugs@arkaria.postgresql.org; Fri, 09 Dec 2022 20:35:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p3fai-0003Xa-Da for pgsql-bugs@lists.postgresql.org; Fri, 09 Dec 2022 15:47:12 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p3fab-00053c-GK for pgsql-bugs@lists.postgresql.org; Fri, 09 Dec 2022 15:47:11 +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=gWVe6J/AInYE5qmQDKaMA/km0N8ANrqd2+n8oB0BY48=; b=hKNC3EWHvGNgYKR0v/+WwTBWO2 0vUFZmRfN3XweS3PVxAobW8n/Un0odBGXTmRrKoR2JfxPsbo5wiFHJZNz+h0X3Pv8F+iJKxMyi0O0 lxSlyXvzvf91jn+CFAx67lXtrHR14QZGDzq7pCtDPxZyddm0NBOewwv1TjZDomyI80AfOMl8Q5awZ jv1b4xtJ1F0PrgOXsGv33DcsBy59WuoML/CeoliEU9sx6NZtF6hwr/nzO8ClWe/30o5iBOSXcfWwB ItlGqfA5uwH9+5UjNuHOxKkeEyg3DHh6lia0sztUaipz1YI7eFWmONgUBy4s3OukI71ZPne+UdDKw mMr90kQw==; 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 1p3faa-0000ym-0G for pgsql-bugs@lists.postgresql.org; Fri, 09 Dec 2022 15:47:04 +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 1p3faY-00B7Km-0P for pgsql-bugs@lists.postgresql.org; Fri, 09 Dec 2022 15:47:02 +0000 Content-Type: multipart/mixed; boundary="===============6437732792302160293==" MIME-Version: 1.0 Subject: BUG #17710: Slow queries (100% CPU) after auto-vacuum To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jf.levesque@gmail.com Reply-To: jf.levesque@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 09 Dec 2022 15:46:04 +0000 Message-ID: <17710-22ff6a35aac256ff@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 --===============6437732792302160293== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzcxMApMb2dnZWQgYnk6ICAgICAgICAgIEplYW4tRnJhbmNvaXMgTGV2 ZXNxdWUKRW1haWwgYWRkcmVzczogICAgICBqZi5sZXZlc3F1ZUBnbWFpbC5jb20KUG9zdGdyZVNR TCB2ZXJzaW9uOiAxMS4xOApPcGVyYXRpbmcgc3lzdGVtOiAgIERvY2tlciBwb3N0Z3JlczoxMS4x OC1idWxsc2V5ZSBvbiBtYWNPUyAxMy4wLjEKRGVzY3JpcHRpb246ICAgICAgICAKCkhpIQ0KDQpJ IGFtIGhhdmluZyBhbiBpc3N1ZSB0aGF0IHN0YXJ0ZWQgd2l0aCAxMS4wIGFuZCBpcyBzdGlsbCBw cmVzZW50IHdpdGggMTEuMTguClRoZSBpc3N1ZSBpcyBub3QgcHJlc2VudCB3aXRoIDEwLjIzLg0K DQpUaGUgcHJvamVjdCBpcyB1c2luZyBEamFuZ28gd2l0aCBQb3N0Z3JlU1FMIGFzIHRoZSBiYWNr ZW5kIERCLiBJIGhhdmUgb25lCnB5dGVzdCB0ZXN0IHRoYXQgaXMgZG9pbmcgYSBsb3Qgb2YgdGhp bmdzICh+NDUwMCBTUUwgcXVlcmllcykgdGhhdCB1c3VhbGx5CnRha2VzIDE3IHNlY29uZHMgdG8g cnVuIHdoZW4gcnVubmluZyBub3JtYWxseS4gVGhlIHNhbWUgdGVzdCBpcyBydW5uaW5nIGZvcgp5 ZWFycyB3aXRob3V0IHByb2JsZW1zLg0KDQpXaGVuIEkgcnVuIHRoaXMgdGVzdCBpbiBhIGxvb3Ag KHdpdGggYSAxMHMgc2xlZXAgYmV0d2VlbiBlYWNoIGV4ZWN1dGlvbiksCmFmdGVyIDEwLTIwIHJ1 bnMsIHRoZSB0ZXN0IHN0YXJ0cyB0byB0YWtlIH4zMDAgc2Vjb25kcy4gQWxsIHN1YnNlcXVlbnQK ZXhlY3V0aW9ucyBhcmUgdGhhdCBsb25nLiBBdCB0aGlzIHBvaW50LCBJIGhhdmUgb25lIHBvc3Rn cmVzcWwgcHJvY2VzcyB0aGF0CmlzIHRha2luZyAxMDAlIENQVSB1dGlsaXphdGlvbiBkdXJpbmcg dGhlIHRlc3RzLg0KDQpXaGVuIEkgaGF2ZSB0aGUgaXNzdWUsIHRoZSBTUUwgcXVlcnkgWzFdIChz ZWUgYmVsb3cpIGlzIHRha2luZyBhIGxvdCBvZiB0aW1lCihiZXR3ZWVuIDI1IGFuZCA1MCBzZWNv bmRzKS4NCg0KRHVyaW5nIG15IHRyb3VibGVzaG9vdGluZywgSSByZWFsaXplZCB0aGF0IHRoZSBz bG93IHF1ZXJpZXMgc3RhcnQgdG8gaGFwcGVuCmFmdGVyIGFuIGF1dG8tdmFjdXVtIG9uIHRoZSB0 YWJsZXMgKHNlZSBsb2dzIFsyXSkuIElmIEkgZGlzYWJsZSB0aGUgYXV0bwp2YWN1dW1zIChhdXRv dmFjdXVtPW9mZiksIEkgYW0gbm90IGFibGUgdG8gcmVwcm9kdWNlIHRoZSBwcm9ibGVtLg0KDQpU aGUgcHl0ZXN0IGV4ZWN1dGlvbiBpcyBkb25lIGluc2lkZSBhIHRyYW5zYWN0aW9uIHRoYXQgaXMg cm9sbGVkIGJhY2sgYWZ0ZXIKdGhlIHRlc3QgaXMgY29tcGxldGVkLiBDYW4gaXQgYmUgcmVsYXRl ZD8NCg0KSSBhbSB0ZXN0aW5nIG1vc3RseSBvbiBtYWNPUyAxMy4wLjEgKE1hY2Jvb2sgUHJvLCBN MSBQcm8pIHdpdGggRG9ja2VyCjQuMTIuMC4gSSBoYXZlIGJlZW4gYWJsZSB0byByZXByb2R1Y2Ug dGhlIHNhbWUgaXNzdWUgb24gQml0YnVja2V0IFBpcGVsaW5lCmFnYWluIHVzaW5nIERvY2tlciBj b250YWluZXJzLiBUaGUgb2ZmaWNpYWwgcG9zdGdyZVNRTCBjb250YWluZXJzIGFyZSBiZWluZwp1 c2VkIHdpdGhvdXQgY29uZmlndXJhdGlvbiBjaGFuZ2VzLg0KDQpJcyB0aGlzIGEga25vd24gaXNz dWU/IElzIHRoZXJlIHNvbWV0aGluZyBJIG5lZWQgdG8gdHVuZT8gSG93IGNhbiBJCnRyb3VibGVz aG9vdCB0aGlzIGlzc3VlPw0KDQpUaGFuayB5b3UgZm9yIHlvdXIgaGVscC4NCg0KSmVhbi1GcmFu Y29pcw0KDQoNClsxXTogVVBEQVRFICJzaGFyZWRfbW9kZWxzX3Nlc3Npb24iIFNFVCAicGxhbl9k aXNhYmxlZCIgPSB0cnVlIFdIRVJFCiJzaGFyZWRfbW9kZWxzX3Nlc3Npb24iLiJpZCIgSU4gKFNF TEVDVCBWMC4iaWQiIEZST00gInNoYXJlZF9tb2RlbHNfc2Vzc2lvbiIKVjAgSU5ORVIgSk9JTiAi c2hhcmVkX21vZGVsc19zZXNzaW9ubW9uaXRvcmluZyIgVjEgT04gKFYwLiJpZCIgPQpWMS4ic2Vz c2lvbl9pZCIpIFdIRVJFIFYxLiJtb25pdG9yaW5nX2lkIiBJTiAoU0VMRUNUIFUwLiJpZCIgRlJP TQoic2hhcmVkX21vZGVsc19tb25pdG9yaW5nIiBVMCBXSEVSRSBVMC4ib3duZXJfaWQiID0gNDQx KSBGT1IgVVBEQVRFIE9GIFYwKQ0KDQoNClsyXSBBdXRvIHZhY3V1bSBsb2dzOg0Kb2JraW9fZGIg ICB8IDIwMjItMTItMDkgMTU6MDI6NDMuMzIzIFVUQyBbODQyXSBMT0c6ICAwMDAwMDogYXV0b21h dGljIHZhY3V1bQpvZiB0YWJsZSAidGVzdC5wdWJsaWMuc2hhcmVkX21vZGVsc19zZXNzaW9ubW9u aXRvcmluZyI6IGluZGV4IHNjYW5zOiAxDQpvYmtpb19kYiAgIHwgICAgcGFnZXM6IDAgcmVtb3Zl ZCwgMTUgcmVtYWluLCAwIHNraXBwZWQgZHVlIHRvIHBpbnMsIDAKc2tpcHBlZCBmcm96ZW4NCm9i a2lvX2RiICAgfCAgICB0dXBsZXM6IDc1MCByZW1vdmVkLCAwIHJlbWFpbiwgMCBhcmUgZGVhZCBi dXQgbm90IHlldApyZW1vdmFibGUsIG9sZGVzdCB4bWluOiAxNzk0DQpvYmtpb19kYiAgIHwgICAg YnVmZmVyIHVzYWdlOiAzMzcgaGl0cywgMSBtaXNzZXMsIDMgZGlydGllZA0Kb2JraW9fZGIgICB8 ICAgIGF2ZyByZWFkIHJhdGU6IDAuMDAyIE1CL3MsIGF2ZyB3cml0ZSByYXRlOiAwLjAwNSBNQi9z DQpvYmtpb19kYiAgIHwgICAgc3lzdGVtIHVzYWdlOiBDUFU6IHVzZXI6IDAuMDAgcywgc3lzdGVt OiAwLjAwIHMsIGVsYXBzZWQ6CjUuMTcgcw0Kb2JraW9fZGIgICB8IDIwMjItMTItMDkgMTU6MDI6 NDMuMzIzIFVUQyBbODQyXSBMT0NBVElPTjogIGxhenlfdmFjdXVtX3JlbCwKdmFjdXVtbGF6eS5j OjQwNw0Kb2JraW9fZGIgICB8IDIwMjItMTItMDkgMTU6MDI6NDMuNzM1IFVUQyBbODQyXSBMT0c6 ICAwMDAwMDogYXV0b21hdGljIHZhY3V1bQpvZiB0YWJsZSAidGVzdC5wdWJsaWMuc2hhcmVkX21v ZGVsc19zZXNzaW9uIjogaW5kZXggc2NhbnM6IDENCm9ia2lvX2RiICAgfCAgICBwYWdlczogMCBy ZW1vdmVkLCA0NDIgcmVtYWluLCAwIHNraXBwZWQgZHVlIHRvIHBpbnMsIDAKc2tpcHBlZCBmcm96 ZW4NCm9ia2lvX2RiICAgfCAgICB0dXBsZXM6IDQ3OSByZW1vdmVkLCAwIHJlbWFpbiwgMCBhcmUg ZGVhZCBidXQgbm90IHlldApyZW1vdmFibGUsIG9sZGVzdCB4bWluOiAxNzk0DQpvYmtpb19kYiAg IHwgICAgYnVmZmVyIHVzYWdlOiAzMzU3IGhpdHMsIDEgbWlzc2VzLCAyIGRpcnRpZWQNCm9ia2lv X2RiICAgfCAgICBhdmcgcmVhZCByYXRlOiAwLjAyMiBNQi9zLCBhdmcgd3JpdGUgcmF0ZTogMC4w NDQgTUIvcw0Kb2JraW9fZGIgICB8ICAgIHN5c3RlbSB1c2FnZTogQ1BVOiB1c2VyOiAwLjAwIHMs IHN5c3RlbTogMC4wMCBzLCBlbGFwc2VkOgowLjM1IHMNCm9ia2lvX2RiICAgfCAyMDIyLTEyLTA5 IDE1OjAyOjQzLjczNSBVVEMgWzg0Ml0gTE9DQVRJT046ICBsYXp5X3ZhY3V1bV9yZWwsCnZhY3V1 bWxhenkuYzo0MDcKCg== --===============6437732792302160293==--