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 1tjine-00Cnxj-7w for pgsql-general@arkaria.postgresql.org; Sun, 16 Feb 2025 17:51:26 +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 1tjinc-009rGS-Rm for pgsql-general@arkaria.postgresql.org; Sun, 16 Feb 2025 17:51:24 +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 1tjinb-009rGK-I9 for pgsql-general@lists.postgresql.org; Sun, 16 Feb 2025 17:51:24 +0000 Received: from fhigh-a4-smtp.messagingengine.com ([103.168.172.155]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tjinZ-001A3C-0n for pgsql-general@postgresql.org; Sun, 16 Feb 2025 17:51:22 +0000 Received: from phl-compute-10.internal (phl-compute-10.phl.internal [10.202.2.50]) by mailfhigh.phl.internal (Postfix) with ESMTP id 2D58E1140244; Sun, 16 Feb 2025 12:51:20 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-10.internal (MEProxy); Sun, 16 Feb 2025 12:51:20 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm2; t=1739728280; x=1739814680; bh=Lt7rR74fsok5tNCvqZU4mPSE8G9sREY9w5wPvNubATk=; b= lR9CwKwakuspUmp0ozHqS1bHM/7q4HFfEYdZNJDlWloNdS3FmRQ9Z4g9kRVcw9Su p0ebYm9CYq3n9r81j8nEba8wg6DlKgLarBlTebRuYfX1wNcssoCX8M4H5IhuKF4V bbqOzwIviA4i3IvOAjhpDXdgmJ4v3C5Q4lsGlRCqpnx0kETchckAzNeI/8SSX0CE Q3uyuRLrHwDtfshPrY8KXi3gUHOVd2a5vvYkpeQeUQ6xi49RuBtzEMHj4VZFaUjz gX+UzsnOr0EH/lOzbgR9sNVS1r1crBmwajYMk8UUEzPR945LUHTdesvyVD0D+sRV sYGiVuZwsdMAYjbcVvXjEA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1739728280; x= 1739814680; bh=Lt7rR74fsok5tNCvqZU4mPSE8G9sREY9w5wPvNubATk=; b=B 3cEv7t7CMcLfv6fYwRqBMkL3SlFvwYCuIF6e66e5EZUptf+jbfVQ7tR0SVh9zotJ qzd/y6Cb0XpuSRZPMO8TgKfTc9w32wT/E1ooZBaq2tIJQT0gexE2Ql3G6FrPN+pm mfmX5wG5zB34bCG5Kiu9efENH9fxzcqwkhmHwV0qlfNAP2hQW0EyGg8YiBvRi21W YgvROGCi/0RITbQjtqvzjLiPD7Buhcia9Kzq20/cuIovBrOUJ1P4y7AoYWn+8V3b 1duD50hk2Vcpbmjp/B0iFwNQ03aDgeiwe3zcVcKY4mwmnzBcNyt1j1qOzaXwvV9C S5Au4YgSa6Z5edeC+a1yA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdehieduudcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenucfjughrpefkffggfgfuvfevfhfhjggtgfesthejredttddv jeenucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvg hrsegrkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpefhveeihfevlefffedt hedukeevfefhfedtgeeifeevteffgfefhedtffetudettdenucevlhhushhtvghrufhiii gvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegr khhlrghvvghrrdgtohhmpdhnsggprhgtphhtthhopeegpdhmohguvgepshhmthhpohhuth dprhgtphhtthhopegvshhtvggvmhgsshhvqdhfohhruhhmseihrghhohhordgtohhmpdhr tghpthhtohephhhtrghmfhhiughssehgmhgrihhlrdgtohhmpdhrtghpthhtoheprhhonh hljhhohhhnshhonhhjrhesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhg vghnvghrrghlsehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 16 Feb 2025 12:51:19 -0500 (EST) Message-ID: Date: Sun, 16 Feb 2025 09:51:18 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Help in vetting outcome of "vacuumdb --analyze-in-stages" - during DB Upgrade from EC2- PGS - Community Edn ver 13.X to 14.X To: Bharani SV-forum , Greg Sabino Mullane , Ron Johnson Cc: pgsql-general References: <0558ddd4d71641bdb41fa49b2425f73c@safrangroup.com> <1482982714.8486017.1735661703839@mail.yahoo.com> <1763130721.4001842.1737733841628@mail.yahoo.com> <132487461.4068668.1737741687606@mail.yahoo.com> <0dc06cb7-33cc-43ba-a95f-535fdf0a0439@aklaver.com> <1751608443.5432365.1738081421269@mail.yahoo.com> <74599d1d-c8a2-4e59-a50d-019dcc973de8@aklaver.com> <200665967.5560583.1738095230696@mail.yahoo.com> <21b5d62a-19d1-413f-9d5e-d681cd2bb91b@aklaver.com> <47454513.6047834.1738179914107@mail.yahoo.com> <1841861276.9581730.1738888679871@mail.yahoo.com> <56243553.9616888.1738893835649@mail.yahoo.com> <940531722.732202.1739711614045@mail.yahoo.com> <6f44101c-ce01-478e-9fb1-138a10f358d9@aklaver.com> <688728245.763369.1739723234892@mail.yahoo.com> <1530912903.785341.1739727814631@mail.yahoo.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: <1530912903.785341.1739727814631@mail.yahoo.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2/16/25 09:43, Bharani SV-forum wrote: > Adrian > Post pg_upgrade command (success ) from DB ver 13.X to 14.X, > I had used following command > > vacuumdb --all --analyze-in-stages You are done then, move on. > > Need your best suggestion to avoid any unknown headache Keep on moving forward. 'unknown headache' is not something I can help with. -- Adrian Klaver adrian.klaver@aklaver.com