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 1vyCak-00HWyF-0n for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Mar 2026 17:34:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vyCah-000WAg-0N for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Mar 2026 17:34:27 +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 1vyCag-000WAY-2i for pgsql-hackers@lists.postgresql.org; Thu, 05 Mar 2026 17:34:27 +0000 Received: from mail-qv1-xf31.google.com ([2607:f8b0:4864:20::f31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vyCae-00000000yEl-0OuU for pgsql-hackers@postgresql.org; Thu, 05 Mar 2026 17:34:26 +0000 Received: by mail-qv1-xf31.google.com with SMTP id 6a1803df08f44-899f8c33c11so44229496d6.1 for ; Thu, 05 Mar 2026 09:34:23 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772732061; cv=none; d=google.com; s=arc-20240605; b=h/l+qnX41zAQr74vBk42KmQspuTnIoxHdCWO5kE2Vq1pzhDOGOF5ie8YCvgEsx1Ogm IpLm/BrxkiPWf24GlIbbqSMvUXc+uZ/jkz2+kAbF9Qnim6mVN6aSE/3oohE1FvxmiLgN OjoFoGdJhXDTBV5gAaNe2jLWWVnX0zkrkDePdV4L1bZ3ie5NNeyyNC5aln6X8H+1Q0uV isL6roL+b0nhedwdHnFekCVjRpBDTK53XtoHyo3x/5s48GVUqV1wAsMGfvQFti+wQbN9 9o2V3ByDjYV6GTQ3i0orko/O4pUttQvSx/yiYeXQAlkR8xIctQZMBikG521V95SxVhpf YT9g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=NiUjdHyS3l5wGIY1VWqYzobGVrXncYIkzx5p530uWwE=; fh=IgrIb4s79haQKcu70s7QbGoPZJezBNd5ENH/EZLwAXc=; b=em5jXE8KjZ24p68nufijxtYdPkx1JeMpucRU9V1ucNUoAVmgefBB6j73itJ9I0mqP4 n6AHTI33FxAzPLR/vIF9ir1mVEawA1DDw7S8pt6wVq9gOQv1oZo4PPeUjMOcdxBe+hcJ wqLmWeTHygVK3eHLsLTXwEOTKrC//DjU3C8irqLEuVHL3aLlax6s+njTBSzI44YIOmTS 7qSjpEMwSicvKwOYwIPwJYrll9x4fE7vJsjNF/jfqmvJBrRe3LzurwXfaLofrvGWYAAP XbHhBj2UznULhUEkfe7EhRuLaomCY3h1iA1TI3yxVDiHwfDs42ZenCYySEn+8LhoWvAR fNxQ==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1772732061; x=1773336861; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=NiUjdHyS3l5wGIY1VWqYzobGVrXncYIkzx5p530uWwE=; b=md1LS2Yn6vYzJsixz0DoFzirnCI5URT9ow1xqnYfelukByvLnQfcnEKlpYqd2h6o84 HSPHJuxqNDH/CmDjeNfGNePqPYZ7Plq7kDDaSwmyBUN6hYWX3j0lh9XMbSJxZPVxdh9c 7UVkC2BnhJdDuwV45cQKPsQikRZiPeRiEcWK7dRmTUhjqmasQs4kHWf+V3e6/XDMUtWc QInZUs4TS8LViKFAnPuRG4IFKmfOww4pUf3yFovhb8A4NMLWoebL8j+6xJE8W5MYRmWP QZNGnwhe2p2GaUJBtY+nqTuBX2arlYIJ3g0Ww2L83YCuz02RjBULSWtmhF63CyvWKGxl bVqg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772732061; x=1773336861; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=NiUjdHyS3l5wGIY1VWqYzobGVrXncYIkzx5p530uWwE=; b=Zh34QlMW4Zo3aQygHk6LSy3GiWSTCtOYxF8QIce0ULuTjobOFyPbxwHa2X7o5qOJCE 7maUEuoEyo44WBB8a4VvCvcA7z0QAaO0agCa65orBPj/Yqwd5hD+aPmZ+QSqwm2wA8i6 Zq6fjVwP/yWo3dObvD8h8pyHNtOJ6neNupgPOCkiEqBOmuoIOv6jvMSmvlCEpHZG1pmM kpMLa1yAD/ejV65pVDStzgY0TW4FudhfvcCTHHuZhDwVcaFiTJjxi4Bw/8Ta9WbPYhK1 +Y2Sjl81Hx2PkYVqGskHSQiklIutlkCMEcyqHkeM7Jrga9PuAEwoSRAR7qeIW3v9gRgD KQ6g== X-Forwarded-Encrypted: i=1; AJvYcCWnW6TRyheHZuJukY51MBQZ66wvL1eGJ6TjTyna5whCNoAScldJBacHCsgzPNCHfjFGEiCVW1rsh1G7+PjG@postgresql.org X-Gm-Message-State: AOJu0YyI4be9JW6r9bFte+s9Lx34Y7QpAk4Phb7b0MKt15j4murG1DYn wfWpuKuvwuTkMgao70dIIXM3e/80GmHI8udbP58l2zjCLp5tmEksKSXpZgfy6NmYBXZ3qCT1XS/ 7MILvL77hQsmGAgpBri1Bk/HzPgtvdoCE1N3tmRB5 X-Gm-Gg: ATEYQzxHU8ycGsN8ej0QGrK7u2udNiZBp/eNqL/Nqm+hJzpA6Q+VywJ2ejvU9J0rSax 5ujK6ATlqhorQ1B7wNnEauyQ3jdvSd4K0jtcN5CsbwRV8mI3XHCmevNzLTI1RZIJv+K+LjXMTOh O83LZvOr6lgNjMKyuNhwtnmM+QRkZmhJjhK3jDtoUVK5tWqMBkrhbtFkbrdyeCp5yVFO8KjErS0 sksqSVBRiwSktUhWyHlKrtZkc72DAZnxn2joc+MqJruiikoH0tei/diywAI4XyG+YMtxusmDozM fYSfmH+Jew== X-Received: by 2002:a05:6214:4017:b0:899:fd4a:64e2 with SMTP id 6a1803df08f44-89a19d01e38mr98607946d6.46.1772732061107; Thu, 05 Mar 2026 09:34:21 -0800 (PST) MIME-Version: 1.0 References: <1669305.1772663689@sss.pgh.pa.us> <1673952.1772666550@sss.pgh.pa.us> In-Reply-To: <1673952.1772666550@sss.pgh.pa.us> From: Jacob Champion Date: Thu, 5 Mar 2026 09:34:10 -0800 X-Gm-Features: AaiRm52QDivoHLFe-UmPqmMLPZ9Cbv9YHkJ0fy__q1O9gwSxhfg3QNnad9l-lLQ Message-ID: Subject: Re: pgsql: Change default value of default_toast_compression to "lz4", when To: Tom Lane Cc: Michael Paquier , PostgreSQL Hackers , Mark Wong Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Mar 4, 2026 at 3:22=E2=80=AFPM Tom Lane wrote: > 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. Thanks for the patches Michael; the farm looks much more verdant now. --Jacob