Message-ID: <514fe5ce4714b7b33cb0a611f0c7b72df413bef5.camel@cybertec.at>
Subject: Re: Update maintenance_work_mem/autovacuum_work_mem to reflect the
 1GB limitation with VACUUM
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: =?ISO-8859-1?Q?Mart=EDn_Marqu=E9s?= <martin.marques@gmail.com>,
	pgsql-docs@lists.postgresql.org
Date: Fri, 04 Jun 2021 14:34:42 +0200
In-Reply-To: 
 <CAD21AoAv5gdFEggmHj-GeSVvkZkhv1fvLf3xe8aPUS7y8tOTNg@mail.gmail.com>
References: 
	<CABeG9LsZ2ozUMcqtqWu_-GiFKB17ih3p8wBHXcpfnHqhCnsc7A@mail.gmail.com>
	 <1c6fa18692a77ff6098dedc0c150df24ffe9db89.camel@cybertec.at>
	 <CAD21AoAv5gdFEggmHj-GeSVvkZkhv1fvLf3xe8aPUS7y8tOTNg@mail.gmail.com>
Content-Type: multipart/mixed; boundary="=-X7NHXK2eDtTbgRFEI2qY"
User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/514fe5ce4714b7b33cb0a611f0c7b72df413bef5.camel%40cybertec.at>
Precedence: bulk


--=-X7NHXK2eDtTbgRFEI2qY
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

On Wed, 2021-06-02 at 18:16 +0900, Masahiko Sawada wrote:
> > > We should add a line that indicates that there is a limitation (that
> > > should be IMO, backported to documentation of earlier versions as it
> > > affects all supported versions), at least until such limitation is
> > > lifted.
> > Here is a patch for that,
> 
> The patch adds the description in the autovacuum_work_mem section.
> Isn't it better to add it in mantenance_work section or VACUUM command
> section since this limitation is not only for autovacuum?

You are right; theoretically, the correct place to document that
would be the VACUUM documentation.  But I guess that most people who
are curious about VACUUM's memory usage will read the documentation for
"maintenance_work_mem" or "autovacuum_work_mem".

I have fixed a typo and added a similar paragraph to "maintenance_work_mem".

Yours,
Laurenz Albe

--=-X7NHXK2eDtTbgRFEI2qY
Content-Disposition: attachment;
	filename="0001-Document-the-1GB-memory-limit-for-VACUUM.v2.patch"
Content-Type: text/x-patch;
	name="0001-Document-the-1GB-memory-limit-for-VACUUM.v2.patch";
	charset="UTF-8"
Content-Transfer-Encoding: base64

RnJvbSBhOTQ4MTFlNDVkZjk2ODQ2Y2IwNTMxNjE1ZTlkNzczZjY5ZDJjYzJkIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h
dD4KRGF0ZTogRnJpLCA0IEp1biAyMDIxIDE0OjMwOjA4ICswMjAwClN1YmplY3Q6IFtQQVRDSF0g
RG9jdW1lbnQgdGhlIDFHQiBtZW1vcnkgbGltaXQgZm9yIFZBQ1VVTQoKLS0tCiBkb2Mvc3JjL3Nn
bWwvY29uZmlnLnNnbWwgfCAxMSArKysrKysrKysrKwogMSBmaWxlIGNoYW5nZWQsIDExIGluc2Vy
dGlvbnMoKykKCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvY29uZmlnLnNnbWwgYi9kb2Mvc3Jj
L3NnbWwvY29uZmlnLnNnbWwKaW5kZXggN2UzMmIwNjg2Yy4uMDk3NjQ5NDUwNiAxMDA2NDQKLS0t
IGEvZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9jb25maWcuc2dt
bApAQCAtMTg4Miw2ICsxODgyLDEyIEBAIGluY2x1ZGVfZGlyICdjb25mLmQnCiAgICAgICAgIHRv
byBoaWdoLiAgSXQgbWF5IGJlIHVzZWZ1bCB0byBjb250cm9sIGZvciB0aGlzIGJ5IHNlcGFyYXRl
bHkKICAgICAgICAgc2V0dGluZyA8eHJlZiBsaW5rZW5kPSJndWMtYXV0b3ZhY3V1bS13b3JrLW1l
bSIvPi4KICAgICAgICA8L3BhcmE+CisgICAgICAgPHBhcmE+CisgICAgICAgIEFsc28sIG5vdGUg
dGhhdCA8Y29tbWFuZD5WQUNVVU08L2NvbW1hbmQ+IGhhcyBhIGhhcmQtY29kZWQgbGltaXQgb2Yg
MUdCCisgICAgICAgIGZvciB0aGUgYW1vdW50IG9mIG1lbW9yeSB1c2VkLCBzbyBzZXR0aW5nCisg
ICAgICAgIDx2YXJuYW1lPm1haW50ZW5hbmNlX3dvcmtfbWVtPC92YXJuYW1lPiBoaWdoZXIgdGhh
biB0aGF0IGhhcyBubyBlZmZlY3QKKyAgICAgICAgYXMgZmFyIGFzIDxjb21tYW5kPlZBQ1VVTTwv
Y29tbWFuZD4gaXMgY29uY2VybmVkLgorICAgICAgIDwvcGFyYT4KICAgICAgIDwvbGlzdGl0ZW0+
CiAgICAgIDwvdmFybGlzdGVudHJ5PgogCkBAIC0xOTAxLDYgKzE5MDcsMTEgQEAgaW5jbHVkZV9k
aXIgJ2NvbmYuZCcKICAgICAgICAgYmUgdXNlZCBpbnN0ZWFkLiAgVGhlIHNldHRpbmcgaGFzIG5v
IGVmZmVjdCBvbiB0aGUgYmVoYXZpb3Igb2YKICAgICAgICAgPGNvbW1hbmQ+VkFDVVVNPC9jb21t
YW5kPiB3aGVuIHJ1biBpbiBvdGhlciBjb250ZXh0cy4KICAgICAgICA8L3BhcmE+CisgICAgICAg
PHBhcmE+CisgICAgICAgIE5vdGUgdGhhdCA8Y29tbWFuZD5WQUNVVU08L2NvbW1hbmQ+IGhhcyBh
IGhhcmQtY29kZWQgbGltaXQgb2YgMUdCCisgICAgICAgIGZvciB0aGUgYW1vdW50IG9mIG1lbW9y
eSB1c2VkLCBzbyBzZXR0aW5nCisgICAgICAgIDx2YXJuYW1lPmF1dG92YWN1dW1fd29ya19tZW08
L3Zhcm5hbWU+IGhpZ2hlciB0aGFuIHRoYXQgaGFzIG5vIGVmZmVjdC4KKyAgICAgICA8L3BhcmE+
CiAgICAgICA8L2xpc3RpdGVtPgogICAgICA8L3Zhcmxpc3RlbnRyeT4KIAotLSAKMi4yNi4zCgo=


--=-X7NHXK2eDtTbgRFEI2qY--