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 1oBgBe-0008W1-Kj for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Jul 2022 17:30: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 1oBgBd-0005zm-E2 for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Jul 2022 17:30:09 +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 1oBgBd-0005xu-0f for pgsql-hackers@lists.postgresql.org; Wed, 13 Jul 2022 17:30:09 +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 1oBgBY-0000Wk-7u for pgsql-hackers@postgresql.org; Wed, 13 Jul 2022 17:30:08 +0000 Received: by mail-io1-xd32.google.com with SMTP id h200so11507224iof.9 for ; Wed, 13 Jul 2022 10:30:03 -0700 (PDT) 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=ewuDDkXGQpKWYVL7KIvWJI8UtFbQv/hudiS12/DtDSY=; b=CIwTLy+8lo9eaPZiXWpchlAaOdcq1ck52s1mpEy/0PPJfX/ipjqRoZvanU4RuAEQGL C4gIc0gct1Ipn1MAV/S/8KKRalDgImGC1kIuSnCHTryvntR/drvDwIj2qaFRsxbKsTU7 GsnOU5Xmv0Xy6I5G2jI5K0DVgIG1C3t4X68V46SqLFKrLCIZs3A4sQ8OqAAba47C82p7 C6l1V1tNeVsu9fmJVPjsMcvF9W0d0Bwfw54PIJhhO8SFXykACRVthRDwNjaMc3qS7kh8 /Pn5ioef7sU+EeeQ2+S0JXQYPuJE12g0OqSVB3Unx+rGwgyUoF4Rp3u/F7UYL5tbvOx6 fJxg== 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=ewuDDkXGQpKWYVL7KIvWJI8UtFbQv/hudiS12/DtDSY=; b=pg1HKDT+Wxj/wvFMwsBS8ezcCx/uxg1WrPUONq/WamU8WKkpNcBfsU2cgkjeQKXIGn dzmlA4GVYS0+AbFGoxOQTVSy1bBuPraIhC/yIAD8ave4O2TiQdrgoEHCkDlf1g5v6Le2 o4dNSxvKbccfxDH0LvVMGtk3WWwS33OPPX53bjw1x8NAJNPSC3bUl92H8e1URtN49pBe hmGNUTqWMFJ5Psq3Zjcaw6uMgjpcrp7E4DuhF0JiFkhUwne/Y79Xi6Je31D38ppNxel5 eoDEjNM4EIzZHIkZHbgY+zUDrrerKhHruVPE+kWpmFYs4DfuGapmK+ItJAKAVHEi1fpd aR0A== X-Gm-Message-State: AJIora9Q27gdGbvuJiv5krofwmjMoudahikPujMKDGZ+COFwL6yi5fjf a1t6tf1AHqt+2BCNRWdwcBwobw== X-Google-Smtp-Source: AGRyM1sGzTb0TVNyV9CgtSe0sl1KPVvOGmQwjlPcl8tVuxDFVacQAnEjcUpDzeUnjZP4ga0xRQaeug== X-Received: by 2002:a02:c882:0:b0:33b:fb2e:9d49 with SMTP id m2-20020a02c882000000b0033bfb2e9d49mr2494124jao.218.1657733402217; Wed, 13 Jul 2022 10:30:02 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id m13-20020a0566022acd00b0067bcc80ac23sm324147iov.1.2022.07.13.10.30.01 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 13 Jul 2022 10:30:01 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 9746E800DAB; Wed, 13 Jul 2022 12:30:00 -0500 (CDT) Date: Wed, 13 Jul 2022 12:30:00 -0500 From: Justin Pryzby To: Kyotaro Horiguchi Cc: andres@anarazel.de, michael@paquier.xyz, nathandbossart@gmail.com, pgsql-hackers@postgresql.org Subject: Re: fix stats_fetch_consistency value in postgresql.conf.sample Message-ID: <20220713173000.GD18011@telsasoft.com> References: <20220616132306.GD29853@telsasoft.com> <20220617.094358.2201653243066915172.horikyota.ntt@gmail.com> <20220622230710.r2m4ex5tlf6mveyh@alap3.anarazel.de> <20220630.173801.662386227537019720.horikyota.ntt@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20220630.173801.662386227537019720.horikyota.ntt@gmail.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 > +# The following parameters are defaultly set with > +# environment-dependent values at run-time which may not match the > +# default values written in the sample config file. > +my %ignore_parameters = > + map { $_ => 1 } ( > + 'data_directory', > + 'hba_file', > + 'ident_file', > + 'krb_server_keyfile', > + 'max_stack_depth', > + 'bgwriter_flush_after', > + 'wal_sync_method', > + 'checkpoint_flush_after', > + 'timezone_abbreviations', > + 'lc_messages', > + 'wal_buffers'); How did you make this list ? Was it by excluding things that failed for you ? cfbot is currently failing due to io_concurrency on windows. I think there are more GUC which should be included here. http://cfbot.cputube.org/kyotaro-horiguchi.html -- Justin