Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g38rG-00070m-OD for pgsql-committers@arkaria.postgresql.org; Thu, 20 Sep 2018 23:59:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g38rF-0007mc-2I for pgsql-committers@arkaria.postgresql.org; Thu, 20 Sep 2018 23:59:41 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g38rE-0007mV-QE for pgsql-committers@lists.postgresql.org; Thu, 20 Sep 2018 23:59:40 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g38rC-0006re-Eb for pgsql-committers@postgresql.org; Thu, 20 Sep 2018 23:59:39 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id BAC5721FAD; Thu, 20 Sep 2018 19:59:37 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Thu, 20 Sep 2018 19:59:37 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; bh=9VArwQR5RLcqVf4Yb94LnMy/eYR8Hw3tLrUxag9G7fU=; b=ZUgNqPvK XQAyW6CHhmMqglc64Fzjfu0LhEuODB2YGyD3hd7yyX31UbXplDxuwVVbI+ikK6tV hpT+CBmh9LeAfjyP5G1Bs0wpod1Dj4MCu0QJ8cEFrEg6CAoH366B+J/oEBQCYsXh dT1qAmfOgUnVTsKc2lc8ga3JTe/IFOKKyLETrx28lhfU99xH98xuCuTkYhBsudph 0W+tclHsEfE0fd+VhK6wnF27fSwblEeBEU+y8Fc8kmdenHVnu6WwqdX3zg/WkXXY +lnhs0ajEN9v5dh+jl/A6WKdH7PZFYHopy+f1Y68Vg7wb8f36g59G8kWQlNLla6/ MkajdVB9gMNZTQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; bh=9VArwQR5RLcqVf4Yb94LnMy/eYR8H w3tLrUxag9G7fU=; b=Pb1auWoT9SsDkT1tQkfDzTGFGc2OLdtdMrfuEmx71uJxx P4uyk4eucJH3kHPEf0PxU8RGmW7Wikfx7xaJCb0Oltg3lnhhUTxMhcqZVjgUJtKw NXVWm5OZEEiZSEEMyOumml70ZsvWAtEjpVy7LXlibSt6ucLs2s2FSO/Yj7PNIWpD bn7i7TT1I6IjS583VMyjJveDgcrgXN+ZHBKFo0wnYUwh8WdmLlCYCgueS92D5sg/ EAsDkymXTvL8yr4OyETdzE29ocSV9Odb3dEndfUEHGo2FuLOFuDw9cigVrFlmnuT 5bFGIc9HiwFayAF7SCKBMM+UqVM0QwSZZI9d1uaLg== X-ME-Proxy: X-ME-Sender: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id A2B4C102DD; Thu, 20 Sep 2018 19:59:35 -0400 (EDT) Date: Fri, 21 Sep 2018 08:59:32 +0900 From: Michael Paquier To: David Steele Cc: Andres Freund , pgsql-committers@postgresql.org Subject: Re: pgsql: Make WAL segment size configurable at initdb time. Message-ID: <20180920235932.GD1338@paquier.xyz> References: <68ea97d6-2ed9-f339-e57d-ab3a33caf3b1@pgmasters.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="lteA1dqeVaWQ9QQl" Content-Disposition: inline In-Reply-To: <68ea97d6-2ed9-f339-e57d-ab3a33caf3b1@pgmasters.net> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --lteA1dqeVaWQ9QQl Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Sep 20, 2018 at 11:48:08AM -0400, David Steele wrote: > > > > - Reports the number of blocks (pages) in a WAL segment file. > - The total size of a WAL segment file in bytes is equal to > - wal_segment_size multiplied by wal_block_size; > - by default this is 16MB. See for > + Reports the size of write ahead log segments. > + The default value is 16MB. See for > more information. > > The GUC wal_segment_size reports as well 16MB in v10 or older versions, so shouldn't the mention to wal_block_size be removed even further down? -- Michael --lteA1dqeVaWQ9QQl Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlukNGQACgkQnvQgOdby QH1i0g/+LTxsFQ30deqCbClbP12HYVIDJ1pDo5J8YQoIqvJnvSp2ktxH8KfKgO8S VAwGh56/S8sxfjVBk64QL+y7EIivwpdSWalCaKx7Hsgi0pN4ZAsV4an4Uh3o4UjD SPUtGhrfMXxsgfgvQriM+waIvmxe+yuiHHXR/rBkuCj5QwMusKom7a8B4GQux65m HQ74frUgVLnTgyJB4ddUBkuQKjtUB5sf4jCIW+4kGErVHYc2fe0EWXxNcshhY8+N J7jTRI1p9h2dQHOb++65Kbz41BhVOx0vZaMhmcqfG8gqo2092gfP4Ndaai7WUVk7 fmLTmHmcEQdlr/kpdxK1pVkeKljI4vmSNr5/GyEGVZ5lJ9uRTkX6T8enl5QxQKu2 IddeSwQtUzZkdaP2okdo1OUgIItNn/dEQP8V27GU8x4K6DH6dxxPQ50sWv5SS7kh pNMiyHX4HNCC34EGI+7CzM9FRNtgWwe5wvJ/PLmYJDMZMhXxGkGGkET3eR4U9YDb TfKp9W4/yL2rdMvplOE1eXFLavQLT8n93gnQoP0va1dL8juuZ5ESHOrvPuTry5g0 6iWh3VXuHNeWJPfXE4Hj+vH147QpIQggXud/KmOWIDgdVhiY2himi44IQHIaUMIh ARznIdWjFbb+jG0nRWwZP2+hbsESZrC+VMjjq3j3lchI4Hp7cMk= =AOdW -----END PGP SIGNATURE----- --lteA1dqeVaWQ9QQl--