Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nSn8I-00070S-Fc for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Mar 2022 21:49:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nSn8G-0000vU-92 for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Mar 2022 21:49:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nSn8F-0000vL-TB for pgsql-hackers@lists.postgresql.org; Fri, 11 Mar 2022 21:49:08 +0000 Received: from mail-io1-xd32.google.com ([2607:f8b0:4864:20::d32]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nSn8C-0001Uv-3O for pgsql-hackers@postgresql.org; Fri, 11 Mar 2022 21:49:07 +0000 Received: by mail-io1-xd32.google.com with SMTP id w7so11680255ioj.5 for ; Fri, 11 Mar 2022 13:49:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=I3Mz+yOZ7qNwLnd61AdMN+RmKNu6mAgdsJp69aDtkQI=; b=s3fNkgH3/MXmXfTdQzmHgXTFgObZVoOvljmaV9QiUVYKs0nR8qGd+XXTAXWMsIN4L4 0GBla9yoy+ENRnWwVKVv6z7EKrcSzUuUFEXur/Als40RGNe3EVEcC6xL+equQJ4NRy8v ZtkKA0EfemBA6AVBB0AIr7B/+LkjkmUDSCYkdjzgEPlG8+iZHuXKDiyUovVtOpVPSr6X ahgQOECVyJdtMQIEQ2/PhVunvmtFC7z4GBEU+cIxaf0k5r4DrtPZb7tJ9bsuVTo0Lb+3 gydszZ2wejXQw9M3sHPxTWrSI/bLJg4vYTFDJRv4O7drNirfkMcLKx8VrmPprZeX/lZR Beug== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=I3Mz+yOZ7qNwLnd61AdMN+RmKNu6mAgdsJp69aDtkQI=; b=W+vsYpgbrzElpMajLcxMPtoulkf9K9supe5t9yg7nzgFFLghoA1+gx3AjmhV/Ouh4b fsWOZKX+PbYwQRIbVQwMaOjVYIHt/J+mOJiUsYIclYJWZmNaJ99rL3Kx6znHjccTDVVD 5KEqAVCwXwXjSLfryqj5g7eEh7KFXrGflW504mupZk0JAl8NXhO7ordAxLGF48cXJRlM pCu/zLE8hJX+h72ykBajnjcBWFF3CvNXlQEvWbwOYERlBszpQB3+zyX50/gCCzLLZBzS Xb0YXGU8fEd7NFZPJaQJWhhCk11CVzOSzUAu6vB96SMAuZbOXZ2bv++neUZQqTmbWgb7 41Mw== X-Gm-Message-State: AOAM5308dQTsuwm++uFT6Lk4zP00Dnsdhk4vQEfG3f5c09w463XyLtEH QPYKJoCBTMDqHzeNG5uTJcA2dQ== X-Google-Smtp-Source: ABdhPJyaVUxTkOPl2v6/7eXuqinOjrinE9x9kPS/CYX4I76xYArTTjMPFV1NUmIn7SCLdUVJu6XkQg== X-Received: by 2002:a6b:ed18:0:b0:646:3e9e:63bd with SMTP id n24-20020a6bed18000000b006463e9e63bdmr9418690iog.108.1647035342318; Fri, 11 Mar 2022 13:49:02 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id 7-20020a056e0220c700b002c75f643efesm3047119ilq.16.2022.03.11.13.49.01 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 11 Mar 2022 13:49:01 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id DD293800747; Fri, 11 Mar 2022 15:49:00 -0600 (CST) Date: Fri, 11 Mar 2022 15:49:00 -0600 From: Justin Pryzby To: Michael Paquier Cc: Andrey Borodin , Peter Eisentraut , Heikki Linnakangas , pgsql-hackers@postgresql.org, Thomas Munro , Peter Geoghegan , Andres Freund , Robert Haas Subject: Re: wal_compression=zstd Message-ID: <20220311214900.GN28503@telsasoft.com> References: <20220222231948.GJ9008@telsasoft.com> <20220304114405.GK27651@telsasoft.com> <20220309131411.GZ27651@telsasoft.com> <20220311042844.GJ28503@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20220311042844.GJ28503@telsasoft.com> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk While rebasing, I realized this should have bumped XLOG_PAGE_MAGIC. Also, there's a dangling "and". + The supported methods are pglz, + lz4 (if PostgreSQL + was compiled with ) and + zstd (if PostgreSQL + was compiled with ) and + The default value is off. + Only superusers can change this setting. -- Justin