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.96) (envelope-from ) id 1vVtBo-009SeQ-2A for pgsql-hackers@arkaria.postgresql.org; Wed, 17 Dec 2025 15:11:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vVtBn-00DU2l-0f for pgsql-hackers@arkaria.postgresql.org; Wed, 17 Dec 2025 15:11:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vVtBm-00DU2d-2w for pgsql-hackers@lists.postgresql.org; Wed, 17 Dec 2025 15:11:43 +0000 Received: from fhigh-b5-smtp.messagingengine.com ([202.12.124.156]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vVtBl-001FPA-1P for pgsql-hackers@lists.postgresql.org; Wed, 17 Dec 2025 15:11:43 +0000 Received: from phl-compute-05.internal (phl-compute-05.internal [10.202.2.45]) by mailfhigh.stl.internal (Postfix) with ESMTP id 7B6787A0090; Wed, 17 Dec 2025 10:11:40 -0500 (EST) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-05.internal (MEProxy); Wed, 17 Dec 2025 10:11:40 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org; 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=1765984300; x=1766070700; bh=6tZFW48Ou3GTpdp+hPeJAO+JX6HlnXw3dyj2bW0Ynj4=; b= KzNTdzaKtzjAln/lAYEa8jHw/8G/nIuy4Cne5pRhbnFNPc3iADRjMLHelHQxPw6c qO/gBw9q1kmA4tB0xqNRfKWEEc++5SM+KNcgguCG8HNSzyMf6iUaTE9D5+r0bQWs Gyy6fwTtYUj1HiFkCT8u9hGeI2eF0JHV9DJpLGM57ImtKgscypaNUh/vZWmYGnO7 ZkLT9cyGOWKYKYRzx2ERFm7ertwzQe/cCRgUIpYVsvZhbcDz0buE3IEyzhRODCmM pGYjL1+XcbAh4svNBuq22B1ztRS/HSlEcGkc4rOiUCLS6PTCe+pAvt19hAqjZn5/ FlqwgjM/F+2VngyRY/5zJg== 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=1765984300; x=1766070700; bh=6 tZFW48Ou3GTpdp+hPeJAO+JX6HlnXw3dyj2bW0Ynj4=; b=WnDFCEPkWKS0vDzIW BSD/kEjiwDiIKQKxc/0Y/LBAbGU+Elm/tpwWaFBI11GOlvE+p1mdD16ES07n44Lj XfalZDJFmRVvwlro3JVgT8pam8uIhY4ShyWSwpbkKCbJkKvkPOWX15ZbE9Xm9ALn VvZqgtA2ojBdZsVqIkSGDun0I52vRr+R+7QEURYr5j5xy3cxRjctI+Mw+mGpGk51 5VQj5nJ1dTbtyPvx2Ct52/6GBdh8Jen0RJzt5Z2g51QSaQ6TIDqM+Q7pBe0HWIOZ kAbFx3kxpDlu6M2Atgdl1Z8D/LSLgxaQg4YOkLLfqS+J0XE/XTkddkfKTjQTJUfE z3Cpg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgdegvdeklecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpefkffggfgfuvfhfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpefrvghtvghrucfg ihhsvghnthhrrghuthcuoehpvghtvghrsegvihhsvghnthhrrghuthdrohhrgheqnecugg ftrfgrthhtvghrnhepheeivdfhuefhueeggfefheegjedtveeuhfethfeufedvudfgtdeu hefgfeduhfffnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrh homhepphgvthgvrhesvghishgvnhhtrhgruhhtrdhorhhgpdhnsggprhgtphhtthhopedv pdhmohguvgepshhmthhpohhuthdprhgtphhtthhopeguhhgrrhhinhhshhgrhhelheesgh hmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhhrggtkhgvrhhssehlihhsthhs rdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 17 Dec 2025 10:11:39 -0500 (EST) Message-ID: <4c70b0f6-5aba-464c-b145-464a620c1222@eisentraut.org> Date: Wed, 17 Dec 2025 16:11:38 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Fwd: [PATCH] Add zstd compression for TOAST using extended header format To: Dharin Shah , pgsql-hackers@lists.postgresql.org References: Content-Language: en-US From: Peter Eisentraut 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 16.12.25 11:51, Dharin Shah wrote: > - Zstd only applies to external TOAST, not inline compression. The 2-bit > limit in va_tcinfo stays as-is for inline data, where pglz/lz4 work fine > anyway. Zstd's wins show up on larger values. This is a very complicated patch. To motivate it, you should show some detailed performance measurements that show these wins.