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 1vxuuS-00HG1s-1Y for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Mar 2026 22:41:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vxuuQ-00EgPT-1r for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Mar 2026 22:41:39 +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 1vxuuQ-00EgPK-0y for pgsql-hackers@lists.postgresql.org; Wed, 04 Mar 2026 22:41:38 +0000 Received: from fout-b2-smtp.messagingengine.com ([202.12.124.145]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vxuuO-00000000ghl-2KK3 for pgsql-hackers@postgresql.org; Wed, 04 Mar 2026 22:41:38 +0000 Received: from phl-compute-06.internal (phl-compute-06.internal [10.202.2.46]) by mailfout.stl.internal (Postfix) with ESMTP id 5FB671D0024E; Wed, 4 Mar 2026 17:41:35 -0500 (EST) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-06.internal (MEProxy); Wed, 04 Mar 2026 17:41:35 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc: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=fm1; t=1772664095; x=1772750495; bh=tTJbVRY9MR oNXV0jxeWTgHNy+H/VaeLL+xZrHecSgkY=; b=QnQnzrmOHa2Hb7aB9qu3l9wRKa DJix2nKt/xPNpb0ZhBe2CXoubo1u/eGrA/zRtRGTRvAgyfh6YwkLvc2gS0rI07w/ FAignSPLoJYNrWFmfSVXEFOFARSz8p3BjS2RCmAovgXXj3qXg7LGYhMuSFlLBVNj LMkvrdnMm8ZX7dS3fc2hpVWm5C061mSZIsqiy178XMh/RPf740MsPjlnHiL+b5IS huDy4dZpQFEwTJI6wCpY1yFOZixWzbSy9yCkfUa0XeQqLJL413Qlz+V0VIFNPb/y 4pXVJDuS1BPpXTxhD1yeJfsNcEjAbcLsaDOeo4hF3J6PIAbSRCFzhTteGgyA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc: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= 1772664095; x=1772750495; bh=tTJbVRY9MRoNXV0jxeWTgHNy+H/VaeLL+xZ rHecSgkY=; b=SfVzDQ+3wYjrR+tDUAv8KW5sIxNY+CDuAAroX3u9nPVwvIneuaF 73DKsOBBS0h8Yjv7yD1CWgS3jLV3iN3M+SofglRMuOqs14CJXK5BCFPOuB1CIUKH b+q/sxNlWFT+WnyEALKzTMLNdl80KNnYd07zmBXQ7J3cYydQS+e994MBlSGxUvsb l7iP93FSHm0+5dwmPeEv15P1cIuMbPGRgU0z6zxZaYbQ9znzLW8FX2S/zosEl9ci 0R/XuSo+3KSUZjixfduSzUHP71Iiem+JOAuN1SGpHz8H2dVKiVwWJ3aeBJm8VFiU V2xi6yJ1odgUW+zzdA9bF+Xtw7HkvszxbbQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgddvieegjeefucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnegfrh hlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeggeeg fffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptdenuc frrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiidp nhgspghrtghpthhtohepfedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepjhgrtg hosgdrtghhrghmphhiohhnsegvnhhtvghrphhrihhsvggusgdrtghomhdprhgtphhtthho pehpghhsqhhlqdhhrggtkhgvrhhssehpohhsthhgrhgvshhqlhdrohhrghdprhgtphhtth hopehmrghrkhifkhhmsehgmhgrihhlrdgtohhm X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 4 Mar 2026 17:41:33 -0500 (EST) Date: Thu, 5 Mar 2026 07:41:29 +0900 From: Michael Paquier To: Jacob Champion Cc: PostgreSQL Hackers , Mark Wong Subject: Re: pgsql: Change default value of default_toast_compression to "lz4", when Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="FEKvZ9yEl0Yjtzkh" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --FEKvZ9yEl0Yjtzkh Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Mar 04, 2026 at 09:01:06AM -0800, Jacob Champion wrote: > I know there's no "good time" to change a configuration default, but > the timing now is especially unfortunate, because Mark maintains many > of those failing animals and he is traveling this week. Any chance we > can delay this patch a bit to coordinate, and keep the buildfarm > green? There will never be a perfect time for such a change. And after that comes the fact I am out for most of the end of the dev cycle (spring vacations and the end of the fiscal year here), so if we were to do again the same thing in two weeks, I would not be able to follow up. For now, I am collecting data about all the buildfarm members showing in red, and I'll send direct notices to each owner through the day to reduce the blast, in the shape of one email for each owner and for all his/her hosts failing. I am wondering if this is going to display bugs with LZ4, actually, the extend of the red-ness of the buildfarm shows that we did not test it much on some niche places. I have enabled it on my machines for a few years now, but it's clearly not a popular choice. -- Michael --FEKvZ9yEl0Yjtzkh Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmmotRkACgkQnvQgOdby QH20qhAApudlXoJ2D6vywtCAxwgJOs8eJHVIsuacD6AV72TFDBxofSyew3JL8cpY Q+HT5pe6NpcrpIVSDFZbP3Fxx2PwLXzkzx91ZPLwGmYcJ9zgS7+l1vL6aKaxGVBp ALM+IFysLLY5iAOdonsW94yJhV7oxJ0Xwtxx166cWPrrTx9VjTbD+1ewWaeHVZQ8 9JoBkzFIMJYMoxxLoSkfl3H6OSYA9IeZbux1kdwwoT0Im+D1o0f5wnn3mOoWu+Oy pvvnirLZPsHLZr4kETT9dZKWv6gDtQbqpJYEdw52b3oRmZDzJhN1x4cu4/66oT7Q dVVhYHs8WhbeNMA88tCrXqZjC9W7FybrNOZZFvYh3uVhhjvmlGgOgQ7bintDzMDt brH7hz4MXMO/XnpHCXDTSnO9/26yfK5y4IYeyZMGNEua+PlTzKZNAawMoL8IQNAG hwWqreB0FZlZBh3m1Gshfeti5RVhluH88wVfXFHPuQA9i5vtdiiICXAAKTKzvpxo jAFNw9FocLwjGohbp8pIDzSXfi567oazOHg+RcDbwxgDzDEWAcq3roD9N2Je0SuP hOGxDZpPPBsplOlU1PcQid6L0Tl8DUsaO7hsdaoPm4GgmsVfmargwn5MJJ8vden4 GHKk4m7zjzxFzTp2jkW8CfEjmB1sRq6ywfDf9nDlzeuklvFAQFU= =c7L6 -----END PGP SIGNATURE----- --FEKvZ9yEl0Yjtzkh--