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 1wpw4G-001vo7-28 for pgsql-hackers@arkaria.postgresql.org; Fri, 31 Jul 2026 22:51:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wpw4F-000Dlp-19 for pgsql-hackers@arkaria.postgresql.org; Fri, 31 Jul 2026 22:51:03 +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 1wpw4F-000Dlh-09 for pgsql-hackers@lists.postgresql.org; Fri, 31 Jul 2026 22:51:03 +0000 Received: from stravinsky.debian.org ([2001:41b8:202:deb::311:108]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wpw4C-00000001MY6-1r9A for pgsql-hackers@postgresql.org; Fri, 31 Jul 2026 22:51:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=debian.org; s=smtpauto.stravinsky; h=X-Debian-User:In-Reply-To:Content-Type:MIME-Version: References:Message-ID:Subject:Cc:To:From:Date:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=VBwiPVWy5MOjxS21KMN6FzHjNG3aFWU+56WQ90bnqa8=; b=c1T/HbQcIYgWMML0ZLvGIU+xh/ rHzLS0TM3FYjN3VC1Lp7JtvzOkX2jZgynY+63kwOcx16OA4T99vJGahTOLJWnyg1qAdLBABgWSuoy gQ7AZ/hFJLD73ZW+kVN8lV8JkZ6fUP38WQJW24SJ7UTpoFvAfh653m+ziuxfkRr5cJYjw8vIRV4TW C8wiBLd1aV7mGxPvkIG6kK/48M0MQZcOS84BYE0cTEstg0VkmoOkAoXiWeBSARstH5D4kJ0LUInhm RfBUOnrVaMdsCbSfRzSRfobEHXK+kErpnDKhTKLYn53wYn2DWD1Lgz26f6BarOvH+IiHyxBn4/hQ5 uianjNcw==; Received: from authenticated-user by stravinsky.debian.org with esmtpsa (TLS1.3:ECDHE_SECP256R1__RSA_PSS_RSAE_SHA256__AES_256_GCM:256) (Exim 4.96) (envelope-from ) id 1wpw3y-00AMU1-1s; Fri, 31 Jul 2026 22:50:46 +0000 Date: Sat, 1 Aug 2026 00:50:45 +0200 From: Christoph Berg To: Tomas Vondra Cc: Andrey Borodin , wenhui qiu , Laurenz Albe , Andres Freund , Jelte Fennema-Nio , Michael Paquier , Japin Li , Fujii Masao , pgsql-hackers , John Naylor Subject: Re: WAL compression setting after PostgreSQL LZ4 default change Message-ID: Mail-Followup-To: Christoph Berg , Tomas Vondra , Andrey Borodin , wenhui qiu , Laurenz Albe , Andres Freund , Jelte Fennema-Nio , Michael Paquier , Japin Li , Fujii Masao , pgsql-hackers , John Naylor References: <50d60598-3fbf-4344-8b07-bf02114f7fd0@vondra.me> <1314f5843859d5f83d5eb0a47b15d9291567cf40.camel@cybertec.at> <856ABCB3-1D3A-4E1D-B694-C258E95CA1AC@yandex-team.ru> <6d594ed0-5705-4026-a30a-2c36a07a970d@vondra.me> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <6d594ed0-5705-4026-a30a-2c36a07a970d@vondra.me> X-Debian-User: myon List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Re: Tomas Vondra > Thanks. FWIW I've brought this up with the RMT, and there seem to be no > objections to getting this done for PG19. Unless someone objects in the > next couple days, I'll get it committed. Thanks! > AFAIK the algorithms make different trade offs - zstd tends to compress > better, but uses (substantially) more CPU. I think it makes sense to > default to lz4, it's clearly better than pglz, with low CPU usage. Yes, lz4 makes sense to me now. zstd is the "can I tune it harder" pick. Christoph