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 1ryyv2-001OAc-9D for pgsql-general@arkaria.postgresql.org; Mon, 22 Apr 2024 19:01:36 +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 1ryyv0-00D4kE-Qy for pgsql-general@arkaria.postgresql.org; Mon, 22 Apr 2024 19:01:34 +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 1ryyv0-00D4Xl-9i for pgsql-general@lists.postgresql.org; Mon, 22 Apr 2024 19:01:34 +0000 Received: from mail-lj1-x235.google.com ([2a00:1450:4864:20::235]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1ryyux-00487o-1h for pgsql-general@lists.postgresql.org; Mon, 22 Apr 2024 19:01:33 +0000 Received: by mail-lj1-x235.google.com with SMTP id 38308e7fff4ca-2d8a2cbe1baso61608641fa.0 for ; Mon, 22 Apr 2024 12:01:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=privatbank.ua; s=google; t=1713812489; x=1714417289; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Pb8JCmus4EEB36+zOPW3qkFbKT4Ki8Cn7+oihy8F3GE=; b=Cx5JUoF+PPWjktF0ecbmg0H0XBErcA2nT/jO0/Yoc969+0rk/CF1eWVDZcI9rEGVIu DACAO1vylnCx+tC31SNETcjaj/kRsytp1yRn6SAiJdNZfVN5XgdvyBIWO1G6u7bUxfl2 UidUwkb22rXZVoPJb3R+zMO2zgnPpcKCeZ8O8= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1713812489; x=1714417289; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Pb8JCmus4EEB36+zOPW3qkFbKT4Ki8Cn7+oihy8F3GE=; b=SpJwjaJg/ZhvLqI0NIPdOW48+Yhe6WGHh2c/AAY+V7p4xfcD6qjqQVOMOnBai9gHEe Y9yw05W9frWG7zxmR3dwwBiTMbrtzImdseRObO9XP71Gf5TrTRXih/2BQ3Rv3ewZH4Iy Bgm6Tt/nMKVGr3rCMdsGjGbM0XK2QeV2uu7YtzizJvwcvTfwcqP8dsXztFtv1WxZrOOr iPt0+7UWtKCOiLW+5DzMmwmvBNSNvKGj2YGijPU1vtoZlRW9kEx6hiCYtXZrsPOFg83Q ctOlyNSZvXhIsM1dtjXs0C7MAzRr8cIFi2Kh0YKx6X5iYhsNJYojM9X1bmF7UTq5avib BafA== X-Gm-Message-State: AOJu0Yw2G9lZjq/Ymxp0W/w00g5aYZnE16v04hk6vB9b7szYvTjwmXT7 D0evY9Cp+EyA0gSR4641LACF2J0jrT1TPVQKb+M9UnwpAMlZ+7BeDLRHqC+MMKah+We22CKhgPI jwSLrVdUbkw0Og329BUf1h9arjvFOLzNMvdoAZFDh1lsyPHdCF212AwzJ7ULbw7LmhjF6c44avB gzo27ItjNQMZ0ZBmejwbK5TfiWrq7XvNWPa/2yQboA4ooe5/TN7PzfoUZaoGV9QFuF1k//lk9Vl zaj49hpAdla1reIysQ+Yt7EvlfqUAovmJ92CEwAag== X-Google-Smtp-Source: AGHT+IFNQK18/i64qx/IVy3ELEzrMwnAJUttEe3tcHeygi68oDaOoIYuoiZYoqklhq895Mv/8h2Utpn81JUb+VO1B/g= X-Received: by 2002:a2e:88d2:0:b0:2d8:8b9e:8e9b with SMTP id a18-20020a2e88d2000000b002d88b9e8e9bmr8855000ljk.11.1713812489107; Mon, 22 Apr 2024 12:01:29 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: =?UTF-8?B?0J7Qu9C10LrRgdCw0L3QtNGAINCv0L3RltC9?= Date: Mon, 22 Apr 2024 22:01:17 +0300 Message-ID: Subject: Re: Performance degradation after upgrading from 9.5 to 14 To: Johnathan Tiamoh Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000a060e40616b41066" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a060e40616b41066 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 VHJ5IHNldHRpbmcgZW5hYmxlX21lbW9pemUgdG8gb2ZmLg0KT3VyIHByYWN0aWNlIGhhcyBzaG93 biB0aGF0IGVuYWJsaW5nIHRoaXMgcGFyYW1ldGVyIGJ5IGRlZmF1bHQgb2Z0ZW4NCnJlc3VsdGVk IGluIGxlc3MgdGhhbiBvcHRpbWFsIHF1ZXJ5IHBsYW5zIGluIHRoZSBjYWNoZS4NCg0KDQrRgdGA LCAxNyDQsNC/0YAuIDIwMjTigK/Qsy4g0LIgMjA6MTMsIEpvaG5hdGhhbiBUaWFtb2ggPGpvaG5h dGhhbnRpYW1vaEBnbWFpbC5jb20+Og0KDQo+IEhlbGxvLA0KPg0KPg0KPiBJIHBlcmZvcm1lZCBh biAgdXBncmFkZSBmcm9tIHBvc3RncmVzcWwtOS41IHRvIHBvc3RncmVzcWwtMTQgYW5kIHRoZQ0K PiBwZXJmb3JtYW5jZSBoYXMgZGVncmFkZWQgZHJhc3RpY2FsbHkuDQo+DQo+IFBsZWFzZSwgaXMg dGhleSBhbnkgYWR2aWNlIG9uIGdldHRpbmcgcGVyZm9ybWFuY2UgYmFjayA/DQo+DQo+DQo+IEtp bmcgUmVnYXJkcw0KPiBKb2huYXRoYW4gVC4NCj4NCj4NCj4NCj4NCgotLSAKCgrQptC10Lkg0LXQ u9C10LrRgtGA0L7QvdC90LjQuSDQu9C40YHRgiDRgtCwINCx0YPQtNGMLdGP0LrRliDQv9C10YDQ tdC00LDQvdGWINGA0LDQt9C+0Lwg0ZbQtyDQvdC40Lwg0YTQsNC50LvQuCDRlCAK0Lpv0L3RhNGW 0LTQtdC90YZp0LnQvdC+0Y4gadC90YTQvtGA0LzQsNGGadGU0Y4sINGJ0L4g0L3QsNC70LXQttC4 0YLRjCDQn9GA0LjQstCw0YLQkdCw0L3QutGDINC5INC/0YDQuNC30L3QsNGH0LXQvdCwINGC0ZbQ u9GM0LrQuCDQtNC70Y8gCtCy0LjQutC+0YDQuNGB0YLQsNC90L3RjyDRhNGW0LfQuNGH0L3QvtGO INCw0LHQviDRjtGA0LjQtNC40YfQvdC+0Y4g0L7RgdC+0LHQvtGOLCDRj9C60ZbQuSDRl9GFINCw 0LTRgNC10YHQvtCy0LDQvdC+LsKg0K/QutGJ0L4g0LLQuCDQvdC1IArQt9Cw0LfQvdCw0YfQtdC9 0LjQuSDQsNC00YDQtdGB0LDRgiwg0YLQviDQvdC1INC80LDRlNGC0LUg0L/RgNCw0LLQsCDQt9Cx 0LXRgNGW0LPQsNGC0LgsINC/0L7RiNC40YDRjtCy0LDRgtC4INCw0LHQviDQutC+0L/RltGO0LLQ sNGC0LggCtGG0LXQuSDQu9C40YHRgi4g0KMg0YDQsNC30ZYg0L/QvtC80LjQu9C60L7QstC+0LPQ viDQvtGC0YDQuNC80LDQvdC90Y8g0L/RgNC+0YHQuNC80L4g0LLQuNC00LDQu9C40YLQuCDQudC+ 0LPQviDRgtCwINC/0L7QstGW0LTQvtC80LjRgtC4IArQsNCy0YLQvtGA0YMuCgpUaGlzIGVtYWls IGFuZCBhbnkgZmlsZXMgdHJhbnNtaXR0ZWQgd2l0aCBpdCBhcmUgY29uZmlkZW50aWFsIAppbmZv cm1hdGlvbiBiZWxvbmdpbmcgdG8gUHJpdmF0QmFuayBhbmQgaW50ZW5kZWQgc29sZWx5IGZvciB0 aGUgdXNlIG9mIHRoZSAKaW5kaXZpZHVhbCBvciBlbnRpdHkgdG8gd2hvbSB0aGV5IGFyZSBhZGRy ZXNzZWQuIElmIHlvdSBhcmUgbm90IHRoZSBuYW1lZCAKYWRkcmVzc9C10LUsIHlvdSBhcmUgbm90 IGF1dGhvcmlzZWQgdG8gZnVydGhlciBzdG9yZSwgZGlzc2VtaW5hdGUgb3IgY29weSBpdC7CoApJ biBjYXNlIG9mIHJlY2VpdmluZyB0aGlzIGVtYWlsIGJ5IG1pc3Rha2Ugd2Uga2luZGx5IGFzayB0 byBkZWxldGUgaXQgYW5kIAppbmZvcm0gdGhlIGF1dGhvci4gCgoKCgoKCg== --000000000000a060e40616b41066 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: base64 PGRpdiBkaXI9Imx0ciI+VHJ5IHNldHRpbmcgZW5hYmxlX21lbW9pemUgdG8gb2ZmLjxicj5PdXIg cHJhY3RpY2UgaGFzIHNob3duIHRoYXQgZW5hYmxpbmcgdGhpcyBwYXJhbWV0ZXIgYnkgZGVmYXVs dCBvZnRlbiByZXN1bHRlZCBpbiBsZXNzIHRoYW4gb3B0aW1hbCBxdWVyeSBwbGFucyBpbiB0aGUg Y2FjaGUuPGRpdj48YnI+PC9kaXY+PC9kaXY+PGJyPjxkaXYgY2xhc3M9ImdtYWlsX3F1b3RlIj48 ZGl2IGRpcj0ibHRyIiBjbGFzcz0iZ21haWxfYXR0ciI+0YHRgCwgMTcg0LDQv9GALiAyMDI04oCv 0LMuINCyIDIwOjEzLCBKb2huYXRoYW4gVGlhbW9oICZsdDs8YSBocmVmPSJtYWlsdG86am9obmF0 aGFudGlhbW9oQGdtYWlsLmNvbSI+am9obmF0aGFudGlhbW9oQGdtYWlsLmNvbTwvYT4mZ3Q7Ojxi cj48L2Rpdj48YmxvY2txdW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJtYXJnaW46MHB4 IDBweCAwcHggMC44ZXg7Ym9yZGVyLWxlZnQ6MXB4IHNvbGlkIHJnYigyMDQsMjA0LDIwNCk7cGFk ZGluZy1sZWZ0OjFleCI+PGRpdiBkaXI9Imx0ciI+SGVsbG8sPGRpdj48YnI+PC9kaXY+PGRpdj48 YnI+PC9kaXY+PGRpdj5JIHBlcmZvcm1lZCBhbsKgIHVwZ3JhZGUgZnJvbSBwb3N0Z3Jlc3FsLTku NSB0byBwb3N0Z3Jlc3FsLTE0IGFuZCB0aGUgcGVyZm9ybWFuY2UgaGFzIGRlZ3JhZGVkIGRyYXN0 aWNhbGx5LjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+UGxlYXNlLCBpcyB0aGV5IGFueSBhZHZp Y2Ugb24gZ2V0dGluZyBwZXJmb3JtYW5jZSBiYWNrID88L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2 Pjxicj48L2Rpdj48ZGl2PktpbmfCoFJlZ2FyZHM8L2Rpdj48ZGl2PkpvaG5hdGhhbiBULjwvZGl2 PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjwvZGl2Pg0KPC9i bG9ja3F1b3RlPjwvZGl2Pg0KCjxicj4KPHAgZGlyPSJsdHIiPjxzcGFuIHN0eWxlPSJ3aGl0ZS1z cGFjZTpwcmUtd3JhcCI+0KbQtdC5INC10LvQtdC60YLRgNC+0L3QvdC40Lkg0LvQuNGB0YIg0YLQ sCDQsdGD0LTRjC3Rj9C60ZYg0L/QtdGA0LXQtNCw0L3RliDRgNCw0LfQvtC8INGW0Lcg0L3QuNC8 INGE0LDQudC70Lgg0ZQg0Lpv0L3RhNGW0LTQtdC90YZp0LnQvdC+0Y4gadC90YTQvtGA0LzQsNGG adGU0Y4sINGJ0L4g0L3QsNC70LXQttC40YLRjCDQn9GA0LjQstCw0YLQkdCw0L3QutGDINC5INC/ 0YDQuNC30L3QsNGH0LXQvdCwINGC0ZbQu9GM0LrQuCDQtNC70Y8g0LLQuNC60L7RgNC40YHRgtCw 0L3QvdGPINGE0ZbQt9C40YfQvdC+0Y4g0LDQsdC+INGO0YDQuNC00LjRh9C90L7RjiDQvtGB0L7Q sdC+0Y4sINGP0LrRltC5INGX0YUg0LDQtNGA0LXRgdC+0LLQsNC90L4uwqA8L3NwYW4+PHNwYW4g c3R5bGU9IndoaXRlLXNwYWNlOnByZS13cmFwIj7Qr9C60YnQviDQstC4INC90LUg0LfQsNC30L3Q sNGH0LXQvdC40Lkg0LDQtNGA0LXRgdCw0YIsINGC0L4g0L3QtSDQvNCw0ZTRgtC1INC/0YDQsNCy 0LAg0LfQsdC10YDRltCz0LDRgtC4LCDQv9C+0YjQuNGA0Y7QstCw0YLQuCDQsNCx0L4g0LrQvtC/ 0ZbRjtCy0LDRgtC4INGG0LXQuSDQu9C40YHRgi4g0KMg0YDQsNC30ZYg0L/QvtC80LjQu9C60L7Q stC+0LPQviDQvtGC0YDQuNC80LDQvdC90Y8g0L/RgNC+0YHQuNC80L4g0LLQuNC00LDQu9C40YLQ uCDQudC+0LPQviDRgtCwINC/0L7QstGW0LTQvtC80LjRgtC4INCw0LLRgtC+0YDRgy48L3NwYW4+ PC9wPjxwIGRpcj0ibHRyIj48c3BhbiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlLXdyYXAiPlRoaXMg ZW1haWwgYW5kIGFueSBmaWxlcyB0cmFuc21pdHRlZCB3aXRoIGl0IGFyZSBjb25maWRlbnRpYWwg aW5mb3JtYXRpb24gYmVsb25naW5nIHRvIFByaXZhdEJhbmsgYW5kIGludGVuZGVkIHNvbGVseSBm b3IgdGhlIHVzZSBvZiB0aGUgaW5kaXZpZHVhbCBvciBlbnRpdHkgdG8gd2hvbSB0aGV5IGFyZSBh ZGRyZXNzZWQuIDwvc3Bhbj48c3BhbiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlLXdyYXAiPklmIHlv dSBhcmUgbm90IHRoZSBuYW1lZCBhZGRyZXNz0LXQtSwgeW91IGFyZSBub3QgYXV0aG9yaXNlZCB0 byBmdXJ0aGVyIHN0b3JlLCBkaXNzZW1pbmF0ZSBvciBjb3B5IGl0LsKgPC9zcGFuPjxzcGFuIHN0 eWxlPSJ3aGl0ZS1zcGFjZTpwcmUtd3JhcCI+SW4gY2FzZSBvZiByZWNlaXZpbmcgdGhpcyBlbWFp bCBieSBtaXN0YWtlIHdlIGtpbmRseSBhc2sgdG8gZGVsZXRlIGl0IGFuZCBpbmZvcm0gdGhlIGF1 dGhvci4gPC9zcGFuPjwvcD48cCBkaXI9Imx0ciI+PGJyPjwvcD48cCBkaXI9Imx0ciI+PHNwYW4g c3R5bGU9IndoaXRlLXNwYWNlOnByZS13cmFwIj48YnI+PC9zcGFuPjwvcD48YnI+ --000000000000a060e40616b41066--