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 1q8zVD-0004Sm-64 for pgsql-general@arkaria.postgresql.org; Tue, 13 Jun 2023 08:35:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q8zVB-0002AG-Ef for pgsql-general@arkaria.postgresql.org; Tue, 13 Jun 2023 08:35:45 +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 1q8zVA-00027s-T2 for pgsql-general@lists.postgresql.org; Tue, 13 Jun 2023 08:35:45 +0000 Received: from smtp50.i.mail.ru ([95.163.41.92]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q8zV5-00261D-SL for pgsql-general@postgresql.org; Tue, 13 Jun 2023 08:35:44 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=mail.ru; s=mail4; h=Subject:From:To:MIME-Version:Date:Message-ID:Content-Type:From:Subject:Content-Type:Content-Transfer-Encoding:To:Cc; bh=7+taP9X9RmdQHKfFMpmQyNZm7Fp0cbojFRkGj5hNMKs=; t=1686645340;x=1686735340; b=PzMQqUEM1W4dss5o01NSyqfZbTraKCPRmg6zRWwQUwEaPB8ET+TkUh+Un8a/Q2AZWtyKtiFipjBZLL2FmNe5eeWwE61fln2HaAMnRnDy8M5NBptmpo7laC7IIs0lxtwLRCyjGh1AuNPuu3kBvfirChN2CHgwkoMKQcTBZ+rLxS1rXVfkGgoAlWhvNj0ugPZzjrm1N8651mkjafdk4mGt0gf2Vb59ByWgxlOzC9QgCVkCDDxMqqSWHS4h5BSkdrP4QyPoaMwLazhYHyL4bCjQ7PmzR5Jc0iEEDvGH3e2Z8ig1yF6+bz3dv2xa2upPqos/w1OtKXZM142B0VuL1hMabw==; Received: by smtp50.i.mail.ru with esmtpa (envelope-from ) id 1q8zV4-00HERh-FK for pgsql-general@postgresql.org; Tue, 13 Jun 2023 11:35:38 +0300 Content-Type: multipart/alternative; boundary="------------Ypja1LKt7DuoglaVdP5Zys06" Message-ID: Date: Tue, 13 Jun 2023 12:35:07 +0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.12.0 Content-Language: en-US To: pgsql-general General From: rihad Subject: pg_upgrade v15 not generating analyze_new_cluster.sh Authentication-Results: smtp50.i.mail.ru; auth=pass smtp.auth=rihad@mail.ru smtp.mailfrom=rihad@mail.ru X-Mailru-Src: smtp X-7564579A: 646B95376F6C166E X-77F55803: 4F1203BC0FB41BD965EFE7F2AC62B27A4FBE589D5EF957DC135893A82E067D8F182A05F5380850404A9935644089FB5AE96FDD81CDEA44BBE363A52934577C98CCFD25C159BE2813 X-7FA49CB5: FF5795518A3D127A4AD6D5ED66289B5278DA827A17800CE77E216A0E97507353EA1F7E6F0F101C67BD4B6F7A4D31EC0BCC500DACC3FED6E28638F802B75D45FF8AA50765F7900637352A1F9739ED04D38638F802B75D45FF36EB9D2243A4F8B5A6FCA7DBDB1FC311F39EFFDF887939037866D6147AF826D841CDC84983C451C5AB62337241B81EB56F9789CCF6C18C3F8528715B7D10C86878DA827A17800CE7850F8B975A76562C9FA2833FD35BB23D9E625A9149C048EE140C956E756FBB7A2CC0D3CB04F14752D2E47CDBA5A96583BD4B6F7A4D31EC0BC014FD901B82EE079FA2833FD35BB23D27C277FBC8AE2E8BE566BBE820FEB67CA471835C12D1D977C4224003CC836476EB9C4185024447017B076A6E789B0E975F5C1EE8F4F765FC2D3298810E47F77B3AA81AA40904B5D9CF19DD082D7633A078D18283394535A93AA81AA40904B5D98AA50765F7900637C5A35DA31AA1D204D81D268191BDAD3D3666184CF4C3C14F3FC91FA280E0CE3D1A620F70A64A45A98AA50765F79006372E808ACE2090B5E1725E5C173C3A84C3C5EA940A35A165FF2DBA43225CD8A89F6736582285900E61156CCFE7AF13BCA4B5C8C57E37DE458BEDA766A37F9254B7 X-C1DE0DAB: 0D63561A33F958A56467F353A24CF8A8A0397DD21306DF78EE2125DBD73267B1F87CCE6106E1FC07E67D4AC08A07B9B067F1C1C3ABB44F3A9C5DF10A05D560A950611B66E3DA6D700B0A020F03D25A0997E3FB2386030E77 X-C8649E89: 1C3962B70DF3F0ADBF74143AD284FC7177DD89D51EBB7742DC8270968E61249B1004E42C50DC4CA955A7F0CF078B5EC49A30900B95165D3403182E70AE6895E07838121AE51F18CF77DAB195119A7399A38322369BBC378261F0EF590BB352281D7E09C32AA3244C8DF9A1DA7AF88BEA6DCFD082AED9AB8C55E75C8D0ED9F6EEBC4AF6B5DE6957CB5DA084F8E80FEBD3CCC70829E2345EA9F0A6D2C91ED28CB6 X-D57D3AED: 3ZO7eAau8CL7WIMRKs4sN3D3tLDjz0dLbV79QFUyzQ2Ujvy7cMT6pYYqY16iZVKkSc3dCLJ7zSJH7+u4VD18S7Vl4ZUrpaVfd2+vE6kuoey4m4VkSEu530nj6fImhcD4MUrOEAnl0W826KZ9Q+tr5ycPtXkTV4k65bRjmOUUP8cvGozZ33TWg5HZplvhhXbhDGzqmQDTd6OAevLeAnq3Ra9uf7zvY2zzsIhlcp/Y7m53TZgf2aB4JOg4gkr2biojbL9S8ysBdXiFgptkn2+1kmnrkOBxzR8c X-Mailru-Sender: 74AC901D72E61D165302087926F40C5ADE71D51B9651C3CF15B0C991A715D80DB7EA9FE7735C3DBFA00D7FFBEFC6EB2A928A2593B14EC4C3430568AAE1C9FDD0C77752E0C033A69E3453F38A29522196 X-Mras: Ok List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------Ypja1LKt7DuoglaVdP5Zys06 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Hi, all. When pg_upgrading from PG 11 to 13, a file analyze_new_cluster.sh was generated in the current directory which ran vacuumdb --all --analyze-in-stages When upgrading from 13 to 15.3 no such file was generated, which made me believe it was no longer necessary. Alas, it wasn't the case. The database was extremely slow after the upgrade chewing up 100% cpu time, and it wasn't until I manually ran vacuumdb" --all --analyze-in-stages that cpu usage dropped. Was there a knob that I missed, or is this just a bug in pg_upgrade 15? Thanks. --------------Ypja1LKt7DuoglaVdP5Zys06 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit

Hi, all. When pg_upgrading from PG 11 to 13, a file analyze_new_cluster.sh was generated in the current directory which ran vacuumdb --all --analyze-in-stages

When upgrading from 13 to 15.3 no such file was generated, which made me believe it was no longer necessary. Alas, it wasn't the case. The database was extremely slow after the upgrade chewing up 100% cpu time, and it wasn't until I manually ran vacuumdb" --all --analyze-in-stages that cpu usage dropped. Was there a knob that I missed, or is this just a bug in pg_upgrade 15? Thanks.

--------------Ypja1LKt7DuoglaVdP5Zys06--