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 1vxvZ4-00HGVD-2N for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Mar 2026 23:23:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vxvY3-00EqvW-2g for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Mar 2026 23:22:36 +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.96) (envelope-from ) id 1vxvY3-00EqvO-1n for pgsql-hackers@lists.postgresql.org; Wed, 04 Mar 2026 23:22:36 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vxvY2-00000000Rlp-1R0V for pgsql-hackers@postgresql.org; Wed, 04 Mar 2026 23:22:35 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 624NMUpX1673953; Wed, 4 Mar 2026 18:22:30 -0500 From: Tom Lane To: Michael Paquier cc: Jacob Champion , PostgreSQL Hackers , Mark Wong Subject: Re: pgsql: Change default value of default_toast_compression to "lz4", when In-reply-to: References: <1669305.1772663689@sss.pgh.pa.us> Comments: In-reply-to Michael Paquier message dated "Thu, 05 Mar 2026 07:51:26 +0900" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1673951.1772666550.1@sss.pgh.pa.us> Date: Wed, 04 Mar 2026 18:22:30 -0500 Message-ID: <1673952.1772666550@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Michael Paquier writes: > We can still introduce DEFAULT_TOAST_COMPRESSION and use lz4 as > default for the GUC if lz4 is included in the build but leave the > switch of --with-lz4 to --without-lz4 out of the equation. This > choice would leave the buildfarm in peace, and it still achieves the > goal of enabling LZ4 in TOAST by default, as long as --with-lz4 is > used. As long as the latter goal is achieved, the point of the change > would be made, at least partially. That works for me as a temporary solution. regards, tom lane