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 1g3Jr4-0005Y9-Jz for pgsql-committers@arkaria.postgresql.org; Fri, 21 Sep 2018 11:44:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g3Jr2-0002x1-QF for pgsql-committers@arkaria.postgresql.org; Fri, 21 Sep 2018 11:44:12 +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 1g3Jr2-0002wt-HK for pgsql-committers@lists.postgresql.org; Fri, 21 Sep 2018 11:44:12 +0000 Received: from mail.thelabyrinth.net ([45.56.70.56]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g3Jqz-0006MD-3Y for pgsql-committers@postgresql.org; Fri, 21 Sep 2018 11:44:11 +0000 Received: from Davids-iMac.local (c-73-39-99-224.hsd1.de.comcast.net [73.39.99.224]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: dsteele) by mail.thelabyrinth.net (Postfix) with ESMTPSA id 09F0A54670; Fri, 21 Sep 2018 11:44:07 +0000 (UTC) Subject: Re: pgsql: Make WAL segment size configurable at initdb time. To: Michael Paquier , Andres Freund Cc: pgsql-committers@postgresql.org References: <68ea97d6-2ed9-f339-e57d-ab3a33caf3b1@pgmasters.net> <20180920235932.GD1338@paquier.xyz> <4b5568f5-72b7-5355-3450-973e11447569@pgmasters.net> <20180921012354.mvkql65radrpv4gx@alap3.anarazel.de> <20180921045316.GI1338@paquier.xyz> From: David Steele Openpgp: preference=signencrypt Autocrypt: addr=david@pgmasters.net; prefer-encrypt=mutual; keydata= xsFNBFSheh0BEADGNb3c1kOaX5OGUDhqHTwJ3JW7XAllfWLdknpRg+/fihgLPPRnQHZhjq28 nmMLqM+C8TjezT2BgVACeu8qqASnuzN/E5+bAl9hVcgCP4eV/lEIWwVxmhcHqSdeWqWZSBRB tf07fLBnz22+3LwVsESN+fanWxnoqqvE0+hyGnCEDhOBkihgbYHuq4vw1+xgoGN1uDk4NShV El0ZWO90P4e5mOWA2Zsex+8YhGJlfRwMpU69okFCvjpWJKE+ufeJdlrxEpSSKW7SQ0kG1VF7 CvDKpF70TCWkb4Bagb6c7lwZrMjxuBnlIvOlV3RRY67PAaVIFRRvQJeJABOPHp8HnH8cwici 7gwwfWBrZZeAdPqs6VNjANqI9uaDasRnD3yHP6CcHIAeCl5hYnzNTkIqBRlnmD5y8s0VRDLr 6JR3FxscOsvwXPJ+He1RpRlxQDlBboaRFUz8endeQHhGUeHyekQcSYUaz4PX3OJBG0Xi7nr8 EOP6zOeP61z3dL8NuO3QjgPiygvS0qwMEPvOYo52nEGYn08nvFVajI8yxOXFnIwnmpgr5gdq nL9ga72tvSyJQAUx+YB7r1bKjRn/Mlt/fPIS5PXONofiO1K8uX+pzvIX6dnm7ihpFf1XC+uG 5+DKBnU7yS7jCRL52GxWHbuC3mT4tvzqH2b13TLng1Y7Izi+hwARAQABzSJEYXZpZCBTdGVl bGUgPGRhdmlkQHBnbWFzdGVycy5uZXQ+wsF5BBMBCAAjAhsDAh4BAheABQsJCAcDBRUKCQgL BBYCAwEFAlShuEECGQEACgkQn830JKJznPPsLhAAtKkIu0mFfxcVqApg4PNjZKYY4TWeN+I+ go/VKX8QWMadr33t8Sxcgyn48bjBYzgWQXhF4rMcFxDxI3ly5bdE8QKZkhFJJT7N2fBoo9Zm ZOsOvPd+5hz07VZpgNSiTXMAphj8+GSTLbYufm/OUnfpS1eovPtPdYPQpNC3RVHA0gtisz26 NgMLg6QN0iQuITs9N+wiaGtyVIornl4XAY2dM/Hvfr1aDFkukNNr52sc/mGqocG/dKC7dONA 3860y2MLszQcbAE45iEkmwpGkvxyc3i3tvdD3VNlVI1MKJUBnxFPUEI0lVq5WpApFSIU31+j aNunKIcfVxRnM8FTJBsw3RnFRpSsEtiLaZRm5sOZHa9+dy/DWDb+8O1I+momCo88+Jksd6pZ 2Tz9msOiJiTnFsCZgfbbmayH6w8ZyfHuO0DuxScM1UK+6CLC2VVjQFuH6WHqJpaENg5INswS qpUc05iC4i+6dZOe44cviX6LpHuP8vWM0E63CMun0l42yHWy+k6nLvx/fj7t++tF2JIJ92OG n/2MkM5lIKknRg27UjYAspD6f3NSZUMIe6tGyWPTtLOu8zOL5CeRyCHMWwUVDKJSBzlK2mV8 e0EbmtUJFsoNWXWKPKUIxX7JXPN3v523HmOhtyz5SnkGtwEqCZiv/JccYmh+S2IokAuscLNP EJrOwU0EVKF6HQEQALPpUsP67xfcj6NUMyySXSytUzMIVi5XNTyazuNcVfFZzT9QL8wFQkgy i/HOD3tmvdGxz6H8V+v+cszp88gCd8TwClss7u+iPsLlAQQWC4q0WiX4OhwFv2H004iuft8i odjiWDkYEgIFxlPNxQfHFmchkyODIJXQmnzbgsXwGZtJzAxEVh6AgYJqE/Ev/+kTJhJ7703n oIb+PXvafoB5axnU4nf7DuFa9X+q2/ZfzyAXUCKvzDvxb24iUgWFzlWBx0CnI21Kh6aS6hR6 o00D2OBiU+yCpW9eRTi3SuDuslmtCUaZz5V4SHo37ochEYfZ2LYOPsBO3PUMx8T7MDYrmv/x 4W5rdjugz4NXWROStNNLpS74LW20rdrEKMDltph7U2zfjjS663K+CUxoXn/ha2WnzBocoY5o KwdViLln4s0ivOTa4clHJJUsYiAxLShAe2AP+5kJim24tAabbEOsrRTn9RpT7J8jVT/G0YDE glujEt0U04Akkj5NO4G7vJP/AyX5zKZetkp/HFiFBZMkUuXD/KgDc5EM2fpQtaxGGY2fcQqY VHUbbxstxyl5d349M9rok7O90hw9BkP0Q8UEpgmlZ6ftwx+ZfZmBEdQ7HcMHnSPSNJkXt/Vi ozlcrSnkVXzCXvH9DHrIpgenp8btsJ2XyjSdrEu4jAqYeirW+3qRABEBAAHCwV8EGAEIAAkF AlSheh0CGwwACgkQn830JKJznPNmERAApYaQK6i9F6hM2RUD/PqQC45WmzOXK9bDSS9hdk4p Nc5jSW2+FkcMFe1XFG2NyGf1v5KBPxuDTQp35PIwRsL59xNmPICu0ae6zmCPUpxbMIEzb/VU wXqeuNp3cRVll06goDt5w+2LlAtBrxuDjiWxby9LH+vsIUMLWYu+M50pdtOcXOsO1+zyfs3w U6xRZ3PaFDKO1cB68okDFG/cFHnYfY5aETV7LgVBHEOQLwL01U01QC/iqY/aNO4iUH/+PBc0 R6mYlP7IqDQOQVTJ0dXP365thl0Q7c9e2JQSS9wuSv2EEiR//nnZREtLyrQNLwsXE8UFBDe7 uA8Lm2ldmQYpHHKAcorGVTHYJaaus2LjH8tZ1i4RGg4hKMJSHil/5C+Ghl+PmcACVeGaxB0c mJ8+0jyWDkLCDMAXJJyvXRWIONTAxVt5kKg1/iMAq1IQYNd66agnmgxdSvKLPUo0JJ5fhQJp 2bqDDTrINTZg+Rub2HeoOMxYJsMypK+6aY4iVlm2Z7A9SgyQDjGAXzD9+XaezNFeXxfPbjo6 46qA9SycdYhiwaTcTQakiLkZWRIkSjGQwNCK9NktE1fYnXfR0+WaWFduQ4BfM5uta1bt8esB /mLEjVYS9RRAWZ/untJrR9JYGTC4Mu6tcLGZD7385yX3TNM1iaIUGxlKkHHCZCnILyo= Message-ID: Date: Fri, 21 Sep 2018 07:44:06 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <20180921045316.GI1338@paquier.xyz> Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="ZAuzgjvjZjywpEsBYvNOBRCUpQFmpYMfh" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --ZAuzgjvjZjywpEsBYvNOBRCUpQFmpYMfh Content-Type: multipart/mixed; boundary="BKdLW4RjA38x4fGC1UnAaBYKyBr4VZEaE"; protected-headers="v1" From: David Steele To: Michael Paquier , Andres Freund Cc: pgsql-committers@postgresql.org Message-ID: Subject: Re: pgsql: Make WAL segment size configurable at initdb time. References: <68ea97d6-2ed9-f339-e57d-ab3a33caf3b1@pgmasters.net> <20180920235932.GD1338@paquier.xyz> <4b5568f5-72b7-5355-3450-973e11447569@pgmasters.net> <20180921012354.mvkql65radrpv4gx@alap3.anarazel.de> <20180921045316.GI1338@paquier.xyz> In-Reply-To: <20180921045316.GI1338@paquier.xyz> --BKdLW4RjA38x4fGC1UnAaBYKyBr4VZEaE Content-Type: text/plain; charset=windows-1252 Content-Language: en-US Content-Transfer-Encoding: quoted-printable On 9/21/18 12:53 AM, Michael Paquier wrote: > On Thu, Sep 20, 2018 at 06:23:54PM -0700, Andres Freund wrote: >> 16*M*B, right? If so, that's normal - pg_settings just reports the >> values in the underlying unit - which is XLOG_BLCKSZ, compile-time >> defaulting to 8KB. 8192 * 2048 =3D 16MB. That's the same in various o= ther >> settings. >=20 > Would it bring less confusion if we append something like "When queryin= g > pg_settings"? I can see David's point the current phrasing is > confusing: we don't know if this comes from pg_settings or from SHOW. > It obviously refers to the former, but one can understand that it refer= s > to the latter. >=20 > A second parameter in config.sgml where this formulation is used is > segment_size. That's why I used a default of 16MB instead of the byte value, because segment_size used 1GB instead of the byte value. --=20 -David david@pgmasters.net --BKdLW4RjA38x4fGC1UnAaBYKyBr4VZEaE-- --ZAuzgjvjZjywpEsBYvNOBRCUpQFmpYMfh Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Comment: GPGTools - https://gpgtools.org iQIzBAEBCgAdFiEEDkRHqfbjxwCMp7jigDa4glDlIUAFAluk2YYACgkQgDa4glDl IUCnaQ//e/M0VQFddUyWxXl8JF+eJmGQIPOORn6/PDwGtZj5p4SAVUPOtJRCG8k5 4c2zq+N3ZygkY8ZJWG/e+n9J4BFPESIoYxhTZ0K50dLBqM5N1SG73pQZ6VmrJzYD bCExnfHHvs0ba99PPpoozJapCYUZ4CBKY9954wE5K/sKovVTAzRrvz4WI3pbiMxV us5XJ2QH2QDXiS845D5UuuVx3ffGTcDLJdKqO1l5DDU0YuBrGFzBUm6mVlHeYuxC /aBoZk2bJ4qPvEUzBYKb4asikUaLF1g9SIL0qWnDP1JJEWWvpGKT3jCom18qetzI vNrI5h7n5SWzrP8/H0iu5Iqdf7ZbTaXvyLRqt7i53SHe4wTsehDC4iL3ptkBhCLf VKCZqVcsLeQOx9bZ0Rd4+C7sJF6EV4nn7k86idgTJBs0nM9pj01sGoRGgh70hCes u9agS7p/qxay61T0JpymZp2VcNAT/Lfv3lHKg05rvtfpn2vPr6fWKkCk8fAuKlRx mSB/hZdlCbz4dcDJCbx6bVQ0KqTyipk/MTi3aELPJQSqiYFIKgN+92tiEe3MCOXl w9Z6R+9JLkFlVF0SdDNJZaE9EfAQXHjZbFDLz9uhE+US4M8YpuOyvLnqbzknXQTd ofB4oT5k8TYcnaX0SH5C0m2WAEE43id7p/CfkFLzioQ18ro7HxQ= =rrLJ -----END PGP SIGNATURE----- --ZAuzgjvjZjywpEsBYvNOBRCUpQFmpYMfh--