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 1vGFtX-00Avrr-H4 for pgsql-general@arkaria.postgresql.org; Tue, 04 Nov 2025 12:12:14 +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 1vGFtW-00DQLy-EC for pgsql-general@arkaria.postgresql.org; Tue, 04 Nov 2025 12:12:13 +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 1vGFtW-00DQLo-2j for pgsql-general@lists.postgresql.org; Tue, 04 Nov 2025 12:12:13 +0000 Received: from fhigh-a6-smtp.messagingengine.com ([103.168.172.157]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1vGFtT-005OrG-0u for pgsql-general@postgresql.org; Tue, 04 Nov 2025 12:12:12 +0000 Received: from phl-compute-03.internal (phl-compute-03.internal [10.202.2.43]) by mailfhigh.phl.internal (Postfix) with ESMTP id B56CD1400202; Tue, 4 Nov 2025 07:12:09 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-03.internal (MEProxy); Tue, 04 Nov 2025 07:12:09 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm1; t=1762258329; x= 1762344729; bh=18wnoJ6ot0W4wzOU9xRNB7nhe0QcbjQeGobBb4fpoz8=; b=j 4EdNJCF7qSZiET8z6MIGIFV6XMiuoL26AdRZY9SYr/w8mAFnnu9qgYLr2Hux2OoI mYhjHzPk58eHIxPVOC2ea6oP6PiFXopF/GFYjqXbSVqjOZQIwDkDjEYtOp/BXi7m wXIKQXy6dArvKL0KBdg1GOIuYpIG6FHXOLd4LFeT8YwAIgiOGEU8OvhEwrHZ0p9w zmKNFYSIcofLQpmN62AQafLQQW7+/B69HCTXko1WFV41RgP2mgHoEduV5vyo1Iwl 9hv6+c7hOezM3BmVc6k2CfpSzXtNhylNq8l52sxxC9KgYeTZArTg25HbG4qq7neu OqMGrDj5Clizb5Ufs/k5A== 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 :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; t=1762258329; x=1762344729; bh=1 8wnoJ6ot0W4wzOU9xRNB7nhe0QcbjQeGobBb4fpoz8=; b=vgyQqvSD/Jk18C1of h9LhHmmsNAJPjgysKIRLUJr3tmpzPm51MIquir9BQQClZn7jfyj/Ko2RNEZ5mBer peHuyJJIuVIuZHc+uMvH28sjemxMIuE6vNtRf6veFmjFk8immWvLIUa9vi0Rh3dZ M4Q4QvjNAh3E05uBJifOjA8uVRj9Cgd+cScIvjE5OJoqpzL8TXpTwCY8snTr3Bd6 T+zXqvixTxBaUj7TwLq3a+n19ql7YPQab2I65/tbdkU1rY8MuxWT4YUsDLCUEFvQ vvOqZC0Qre3flG0+LVgcjZ3Hev5fYpKuHEVsA8kQuMJxyRWZ8P/0LVhV2lht3XVV g9DMg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggddukedtleelucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepfffhvfevuffkgggtugfgjgesthekredttddtjeenucfhrhhomheplmhlvhgrrhho ucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsehkuhhrihhlvghmuhdruggvqeenucggtf frrghtthgvrhhnpeetuedvheffkeevgfeuheevteevkefggedttdeufeeuheduuddthfef fffhjeefffenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmnecuvehluh hsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghrrhgv sehkuhhrihhlvghmuhdruggvpdhnsggprhgtphhtthhopeekpdhmohguvgepshhmthhpoh huthdprhgtphhtthhopehlrghurhgvnhiirdgrlhgsvgestgihsggvrhhtvggtrdgrthdp rhgtphhtthhopegthhhrihhsrdhtrhgrvhgvrhhssehgmhgrihhlrdgtohhmpdhrtghpth htoheprhhonhhljhhohhhnshhonhhjrhesghhmrghilhdrtghomhdprhgtphhtthhopegs rhhutggvsehmohhmjhhirghnrdhushdprhgtphhtthhopehkrghirdifrghgnhgvrhesph gvrhgtohhnrgdrtghomhdprhgtphhtthhopehpghhsqhhlqdhgvghnvghrrghlsehpohhs thhgrhgvshhqlhdrohhrghdprhgtphhtthhopegtlhgrhidrjhgrtghkshhonhesqhhuvg hsthdrtghomhdprhgtphhtthhopeigohhfsehthhgvsghuihhlugdrtghomh X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 4 Nov 2025 07:12:08 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1762258327; bh=doP/BRwBoxTm5bLGIA60pzmhxZ/noNa2OIxOsUtsk4g=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=wXYKVOj3t4rmsYcev0bSh2lRVSRjX343H6l0myBxbjNijWwKSGoXJXx7O6cnGEegG r0/TUmJ6i8WF/aMH+VZydiBLu64Ji9nkEUgQrO9XsDIAriWk/OzQyDRcwORMBzZRrF avNhtmijfUSiAsZqt5wb1JCLAAi+9NYK4RNo+uaqVd2H/gazbpDCYP4aTyiK0on6mJ 2evSnnYyeKQL14Ne4eUG4Yv/LattU5yIRMgKHmsljCqRqIHSfL4WF8VKQaGMPSk06e YTf1FYqbm8LNIeK7R+/9VAT4Zbr3qSSDQPenI9qe06EwFNHLL3GJ2h1tTGqXbLYFOP lmZZ9EUphmyTw== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id 19C4176; Tue, 04 Nov 2025 14:12:07 +0200 (EET) Date: Tue, 4 Nov 2025 13:12:07 +0100 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Laurenz Albe Cc: Bruce Momjian , Kai Wagner , Chris Travers , Christophe Pettus , "Clay Jackson (cjackson)" , pgsql-general , Ron Johnson Subject: Re: Enquiry about TDE with PgSQL Message-ID: <202511040820.vd7dfekwgq7k@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-Nov-04, Laurenz Albe wrote: > 9.6, which introduced parallel query, only supported it for sequential > scans, which was much less useful than what we have today. I for one > wouldn't consider an implementation of TDE with some features missing > "not worth it". We call this incremental development, and we've accepted that it might be the only way to get complex features developed. We did it for partitioning, parallel query, AIO, and lots of other things. IMO it's a good strategy, even if we sometimes have to backtrack. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "No tengo por qué estar de acuerdo con lo que pienso" (Carlos Caszeli)