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 1nSWtb-0005hx-A6 for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Mar 2022 04:28:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nSWta-0000jR-0j for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Mar 2022 04:28:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nSWtZ-0000ig-Km for pgsql-hackers@lists.postgresql.org; Fri, 11 Mar 2022 04:28:53 +0000 Received: from mail-io1-xd2d.google.com ([2607:f8b0:4864:20::d2d]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nSWtS-0007kl-7M for pgsql-hackers@postgresql.org; Fri, 11 Mar 2022 04:28:52 +0000 Received: by mail-io1-xd2d.google.com with SMTP id x4so8901773iop.7 for ; Thu, 10 Mar 2022 20:28:46 -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=ituuhj4fmYzO83GiGQyY4MvQoNnnrMckMpFO2Lo+qmc=; b=RgI9tTR+q9vMcSDXGyvWpBy+AWejD/fbnRByc/oUnWigVO7d1jpKatriOYLUCYrq/7 MtShOJkqKkNgnf+13ZSNJz0pyDCVI01avyjM713+UpIgaIvUR4z8rPf5WV/uSHHAA/J5 knq27RtH9ZNMi8kU6MS39EY6Re/PTOtuhWVnQ0fj5QmleF63Z+KhRHjLRwFBokTgo8fM 7n4tVp+FuDJ6lUmgHyJs0dz8EsrIJDBcL288BjK/V2JF8hO//bpqALswA+qqKjI9wAMr qukQkqonE82A8ZGUTMYu7Lno2cGAT3FR1z+Kpb6mSsKV9wzffOGXAVaKdbCJF8slOssv rtJA== 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=ituuhj4fmYzO83GiGQyY4MvQoNnnrMckMpFO2Lo+qmc=; b=Jv6bEXtO/0GkMIlg81GO62Lxf8Dcl7jkHE1BsTXcJK+YbAyh4nTvCDipaVAE+WqD8A 1VMYCTor7BNrF52Vf0FmQFs5Lvn9GAcQu0MQKpEcDwY1Fo07FT0H5yVlXdzALxyjwdSZ jJME+GN8QQY1qmVOZENeXC5Sr689BrjBAxioNjbAqYCu1qbqQTpcNK+gtxQwdzcy9GkP lteL6/RI+FpruMc2ndoMjoCLrvVxyFk0GX2RYkCzug8XEFDZaZV4zJdxqH7tOIRPaoun fyvjWItKUX5PsjOnwSQcemw/rg1uSMEBRN0SPzYKGpcML37qjX34Af1PTdtLu6Kn/SXu lZDA== X-Gm-Message-State: AOAM533ZS4tNPKiwvJHAwLk50KFYrWaeZFKP1JTbfIBDPli4klEN2ub+ dC06c1gvqhzaWT9lBuBQb5ml4A== X-Google-Smtp-Source: ABdhPJxxj6h9Mgokp7NNe6qyY5TxX661teUYaw4y+beanekp6c4tsyOqKmLLUS57bNVbqIOx/zYO7g== X-Received: by 2002:a05:6638:358c:b0:318:c544:1d with SMTP id v12-20020a056638358c00b00318c544001dmr7256689jal.86.1646972925504; Thu, 10 Mar 2022 20:28:45 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id h12-20020a056e021b8c00b002c76e6682dasm1344370ili.19.2022.03.10.20.28.44 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 10 Mar 2022 20:28:45 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 3E94E800DD5; Thu, 10 Mar 2022 22:28:44 -0600 (CST) Date: Thu, 10 Mar 2022 22:28:44 -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: <20220311042844.GJ28503@telsasoft.com> References: <20220222231948.GJ9008@telsasoft.com> <20220304114405.GK27651@telsasoft.com> <20220309131411.GZ27651@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: 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 On Fri, Mar 11, 2022 at 12:23:59PM +0900, Michael Paquier wrote: > On Wed, Mar 09, 2022 at 07:14:11AM -0600, Justin Pryzby wrote: > > Anyway there's no compelling reason to not use the default. If we were to use > > a non-default default, we'd have to choose between 1 and 2 (or some negative > > compression level). My thinking was that zstd-1 would give the lowest-hanging > > fruits for zstd, while minimizing performance tradeoff, since WAL affects > > interactivity. But choosing between 1 and 2 seems like bikeshedding. > > Yeah, I have looked again at the patch today, and I saw no reason to > not apply it to give more options to the user as zstd or lz4 are both > good in their own ways. So done, with the default level used. It's great news - thanks. -- Justin