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 1v1rMq-00DOe2-94 for pgsql-general@arkaria.postgresql.org; Thu, 25 Sep 2025 19:11:00 +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 1v1rMo-004zeW-Tu for pgsql-general@arkaria.postgresql.org; Thu, 25 Sep 2025 19:10:58 +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 1v1rMn-004zeO-Nh for pgsql-general@lists.postgresql.org; Thu, 25 Sep 2025 19:10:58 +0000 Received: from fhigh-a8-smtp.messagingengine.com ([103.168.172.159]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1v1rMi-002Pt1-1F for pgsql-general@postgresql.org; Thu, 25 Sep 2025 19:10:56 +0000 Received: from phl-compute-05.internal (phl-compute-05.internal [10.202.2.45]) by mailfhigh.phl.internal (Postfix) with ESMTP id D064F140007F; Thu, 25 Sep 2025 15:10:47 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-05.internal (MEProxy); Thu, 25 Sep 2025 15:10:47 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= 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=fm3; t=1758827447; x=1758913847; bh=pwovZj3VSaBvpe43ePgVlNuzlVuf2L6kfKckq1jooa8=; b= Z7G98Nw0rL58fmiJvZ+jVhVb9sAQkQqgMxoCOoufJgf/16g6dzM6FKhqm9bPZkkO i5D30vBbcWNFpCT/slMTMJDdgT47a502Op9kKgWfhN0+8jtP7cIhmtnCRqKRGxns sa87PX+192I5MmhEMOpxA9AhZsqVCyER1c8uJ5tnULy6a9xwE3FWeShX3+8RvVZx M4hTgJ8Tj828O81lrul82AFUE/SBlypPp9gSTaVnUy1C5ptZjhllJjGwPr+gROBH jTMMAM6WZicSpz44m16HOtPE4bcx42Ls2QW2QP/wWEe6UgQVayYTvkNUuxkzt0xm oa6pcGYlGNKklYDPtFOc7g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=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=fm1; t=1758827447; x=1758913847; bh=p wovZj3VSaBvpe43ePgVlNuzlVuf2L6kfKckq1jooa8=; b=bJQBUcxBK2iDv8USm yrm1u5d8B2ed2r51rvvbx9Gu6VPfliccLIl1jq2KOo3X/dcCpclDu/60LLimft9n xv6ggLYws/IwWYJ+AEJzM8l26RL6gS72xm53uc3/mBAaIbAYi/iL6f1NW2eO4UK2 /ReawIUlpkDODWSzcFKZsGpA9A/RUTiXU+hAr0LG0m80KCIEGOIgguSAIW4SZ3iR eNQUty9ARx9+Q7ZWHlla7pSuDCl4rQE8gMY1aJFYEbYxOhG5/AshlITX4TDphPEI GUq07PRDJo7TOdEC2p5RwvotNAwRVLsEZa19E1G24adrkOqoI7sWNKZ+gkaFvjO6 HbLiw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggdeijedvlecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpefkffggfgfuvfhfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpeetughrihgrnhcu mfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomheqne cuggftrfgrthhtvghrnhepiedvhfeiheehgeeuieeljeeitedtjeehudegfeelkedvleek hedtgfeiffefkedunecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilh hfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomhdpnhgspghr tghpthhtohepvddpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtoheprghshhhishhhrd hmuhhkhhgvrhhjvggvsehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqghgv nhgvrhgrlhesphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 25 Sep 2025 15:10:47 -0400 (EDT) Message-ID: <316ad242-3d52-49ca-b219-998798ed4b5c@aklaver.com> Date: Thu, 25 Sep 2025 12:10:46 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Enquiry about Percona TDE performance issues To: Ashish Mukherjee , pgsql-general@postgresql.org References: Content-Language: en-US From: Adrian Klaver In-Reply-To: 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 9/25/25 04:36, Ashish Mukherjee wrote: > Hello, > > I recently upgraded from pgsql 12 to pgsql 17. It's a Percona TDE > enabled database. However, after the upgrade the query planning time has > shot up by 10x when I check explain analyze output. Did the Postgres 12 instance have the Percona TDE extension installed also? How did you do the upgrade? Did you run ANALYZE on the new Postgres 17 instance? > > Regards, > Ashish -- Adrian Klaver adrian.klaver@aklaver.com