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 1mTn29-0002zc-KI for pgsql-docs@arkaria.postgresql.org; Fri, 24 Sep 2021 15:22:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mTn28-0001d0-CM for pgsql-docs@arkaria.postgresql.org; Fri, 24 Sep 2021 15:22:40 +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 1mTn27-0001ce-4S for pgsql-docs@lists.postgresql.org; Fri, 24 Sep 2021 15:22:39 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mTn24-0001Hd-8m for pgsql-docs@lists.postgresql.org; Fri, 24 Sep 2021 15:22:38 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id 27F345C023F; Fri, 24 Sep 2021 11:22:35 -0400 (EDT) Received: from imap21 ([10.202.2.71]) by compute1.internal (MEProxy); Fri, 24 Sep 2021 11:22:35 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eulerto.com; h= mime-version:message-id:in-reply-to:references:date:from:to:cc :subject:content-type; s=fm2; bh=X0UaifIP6x14S5r4027d52sBkEFlsri Dm6WHqEgD4M8=; b=U2kUIBojKSkCkroMi/NnzXShWBeGTP95U1PGlo4dRU0g8jP tjIscP3yEst1SwzjbhxBBXWo0IOt9wvPaSkKbZhbTulDN3L2/mOjm5UpceqQW8wE 6s/JGzjYXJnLAsQbqt77wTqLakyXq8Z+dDM24FMICjsxIVp9onPLsoNG8wvnaxBM dFqQby5DFekKy8GK8A7M/N7alMoEKBaJ7QnrX4Qwi+KOwf/0Yhj6NSlg9QUISUp5 PlKC5sBQByqg8FQox81sVll7u0g8LX4XoQ11RWElLxBHZB0qRygH/9aHswsLo2KV N2EZaVI0dYbIDip6nH6V55jq1Y1mU8bFNnhUtPg== 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-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=X0Uaif IP6x14S5r4027d52sBkEFlsriDm6WHqEgD4M8=; b=lDDSx7f+SDpboNQCFGpkD9 /iysMgTnjCfglVBp46hmw5pZuqMNYUaQDy4yQIvsJu2vVWFi4wKUEXdiR+81E/rQ iz1sJgUNPqShQmlKrlZJm7oYoeZQBRw76/qrOHE3mIjUCro/wVm77EOXSZ0TdnYk s25tOVXsUOsyIylquyW3w+b+/5arLFaAf89b6Y2KPTrvcGWFtzKnztYDf4OMDXLB M5QWWuXbonBTcLIvimMPbf6bf6Yb+PS7xQHEgALYS/XVkCDD01XgPsTPcSwYw8Sh iwsEZvHu2uEtaJY9kxz42lPfs5oUsZJflhft7BPE3mCW20mKhCU2eU4A8zQv1bDA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvtddrudejuddgkeeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepofgfggfkjghffffhvffutgesmhdtreerreertdenucfhrhhomhepfdfguhhl vghrucfvrghvvghirhgrfdcuoegvuhhlvghrsegvuhhlvghrthhordgtohhmqeenucggtf frrghtthgvrhhnpefhvdelgfekvdetjeejtefhudejfeeileetjeeufeetffegjedtvdeu kedtgeffgeenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmnecuvehluh hsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepvghulhgvrhesvghu lhgvrhhtohdrtghomh X-ME-Proxy: Received: by mailuser.nyi.internal (Postfix, from userid 501) id 5BA0251C0060; Fri, 24 Sep 2021 11:22:34 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.5.0-alpha0-1303-gb2406efd75-fm-20210922.002-gb2406efd Mime-Version: 1.0 Message-Id: <5e51539f-e4b6-4b46-b995-23a2c17252e8@www.fastmail.com> In-Reply-To: References: <1kIqf6Q1G-wVkQkeg_BRSpcmy77hNfh9vlLQ3AF1APT-pKHRYT3z1IuDC5K2w83-4Qa016V1SfWJfF1v0Z0qf6141DbLcpIZJY3edlBEkCs=@pm.me> <2a_0HzEWsHbu9VVZKMxdZ-YxVvFqamXG4crWy1xNkE4NIF-VjRuquYqzrNzmq8-2kJorJymk1D7CDbC2JgYA-BBGibPcxzWQ6R1WTtGMacE=@pm.me> <2806390d2974dc98598a60947395703dc1eead9a.camel@cybertec.at> Date: Fri, 24 Sep 2021 12:21:40 -0300 From: "Euler Taveira" To: "Michael Paquier" , "Laurenz Albe" Cc: "nikolai.berkoff" , "pgsql-docs@lists.postgresql.org" Subject: Re: Missing mention of autovacuum_work_mem Content-Type: multipart/mixed; boundary=85da15886f224e1e8ed17aba9728d1aa List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --85da15886f224e1e8ed17aba9728d1aa Content-Type: multipart/alternative; boundary=d66753c57c194c3b85a135ba6eb5c78a --d66753c57c194c3b85a135ba6eb5c78a Content-Type: text/plain On Thu, Sep 23, 2021, at 7:18 AM, Michael Paquier wrote: > On Thu, Sep 23, 2021 at 10:48:37AM +0200, Laurenz Albe wrote: > > Thanks, and +1 from me. > > maintenance_work_mem would be used in the context of autovacuum if > autovacuum_work_mem is -1, but it seems to me that the suggested > wording sounds like only autovacuum_work_mem is used and that it would > never fall back to maintenance_work_mem, no? I would suggest the > addition of "if specified" in the new part within parenthesis > Good point. However, I prefer "if set". -- Euler Taveira EDB https://www.enterprisedb.com/ --d66753c57c194c3b85a135ba6eb5c78a Content-Type: text/html Content-Transfer-Encoding: quoted-printable
On Thu, Sep 23,= 2021, at 7:18 AM, Michael Paquier wrote:
On Thu, Sep 23, 2021 at 10:48:37AM +0200,= Laurenz Albe wrote:
> Thanks, and +1 from me.

maintenance_work_mem would be used in the context o= f autovacuum if
autovacuum_work_mem is -1, but it seems to= me that the suggested
wording sounds like only autovacuum= _work_mem is used and that it would
never fall back to mai= ntenance_work_mem, no?  I would suggest the
addition = of "if specified" in the new part within parenthesis

<= /div>
Good point. However, I prefer "if set".
=


--
Euler Taveira
EDB   https://www.enterprisedb.com/

<= /body> --d66753c57c194c3b85a135ba6eb5c78a-- --85da15886f224e1e8ed17aba9728d1aa Content-Disposition: attachment;filename="v2-0001-Improve-vacumming-indexes-description.patch" Content-Type: text/x-patch; name="v2-0001-Improve-vacumming-indexes-description.patch" Content-Transfer-Encoding: BASE64 RnJvbSBmYjk2NzJkNTg1MjBmNDUyYjI3ZjE3NDdkMmVkMTNkZGY5ZjU2NThlIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBFdWxlciBUYXZlaXJhIDxldWxlci50YXZlaXJhQGVu dGVycHJpc2VkYi5jb20+CkRhdGU6IFdlZCwgMjIgU2VwIDIwMjEgMTQ6NDc6MTIgLTAzMDAK U3ViamVjdDogW1BBVENIIHYyXSBJbXByb3ZlIHZhY3VtbWluZyBpbmRleGVzIGRlc2NyaXB0 aW9uCgpNZW50aW9uIGF1dG92YWN1dW1fd29ya19tZW0gaWYgVkFDVVVNIGlzIHJ1biBieSBh dXRvdmFjdXVtLgoKUmVwb3J0ZWQtYnk6IE5pa29sYWkgQmVya29mZgpBdXRob3I6IExhdXJl bnogQWxiZQpSZXZpZXdlZC1ieTogTmlrb2xhaSBCZXJrb2ZmLCBNaWNoYWVsIFBhcXVpZXIs IEV1bGVyIFRhdmVpcmEKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8xa0lxZjZR MUctd1ZrUWtlZ19CUlNwY215NzdoTmZoOXZsTFEzQUYxQVBULXBLSFJZVDN6MUl1REM1SzJ3 ODMtNFFhMDE2VjFTZldKZkYxdjBaMHFmNjE0MURiTGNwSVpKWTNlZGxCRWtDcyUzRCU0MHBt Lm1lCi0tLQogZG9jL3NyYy9zZ21sL21vbml0b3Jpbmcuc2dtbCB8IDUgKysrLS0KIDEgZmls ZSBjaGFuZ2VkLCAzIGluc2VydGlvbnMoKyksIDIgZGVsZXRpb25zKC0pCgpkaWZmIC0tZ2l0 IGEvZG9jL3NyYy9zZ21sL21vbml0b3Jpbmcuc2dtbCBiL2RvYy9zcmMvc2dtbC9tb25pdG9y aW5nLnNnbWwKaW5kZXggMjI4MWJhMTIwZi4uYzJmMmEzYTdhOCAxMDA2NDQKLS0tIGEvZG9j L3NyYy9zZ21sL21vbml0b3Jpbmcuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvbW9uaXRvcmlu Zy5zZ21sCkBAIC02MTQ3LDggKzYxNDcsOSBAQCBTRUxFQ1QgcGdfc3RhdF9nZXRfYmFja2Vu ZF9waWQocy5iYWNrZW5kaWQpIEFTIHBpZCwKICAgICAgICA8Y29tbWFuZD5WQUNVVU08L2Nv bW1hbmQ+IGlzIGN1cnJlbnRseSB2YWN1dW1pbmcgdGhlIGluZGV4ZXMuICBJZiBhIHRhYmxl IGhhcwogICAgICAgIGFueSBpbmRleGVzLCB0aGlzIHdpbGwgaGFwcGVuIGF0IGxlYXN0IG9u Y2UgcGVyIHZhY3V1bSwgYWZ0ZXIgdGhlIGhlYXAKICAgICAgICBoYXMgYmVlbiBjb21wbGV0 ZWx5IHNjYW5uZWQuICBJdCBtYXkgaGFwcGVuIG11bHRpcGxlIHRpbWVzIHBlciB2YWN1dW0K LSAgICAgICBpZiA8eHJlZiBsaW5rZW5kPSJndWMtbWFpbnRlbmFuY2Utd29yay1tZW0iLz4g aXMgaW5zdWZmaWNpZW50IHRvCi0gICAgICAgc3RvcmUgdGhlIG51bWJlciBvZiBkZWFkIHR1 cGxlcyBmb3VuZC4KKyAgICAgICBpZiA8eHJlZiBsaW5rZW5kPSJndWMtbWFpbnRlbmFuY2Ut d29yay1tZW0iLz4gKG9yLCBpbiB0aGUgY2FzZSBvZiBhdXRvdmFjdXVtLAorICAgICAgIDx4 cmVmIGxpbmtlbmQ9Imd1Yy1hdXRvdmFjdXVtLXdvcmstbWVtIi8+LCBpZiBzZXQpIGlzIGlu c3VmZmljaWVudCB0byBzdG9yZQorICAgICAgIHRoZSBudW1iZXIgb2YgZGVhZCB0dXBsZXMg Zm91bmQuCiAgICAgIDwvZW50cnk+CiAgICAgPC9yb3c+CiAgICAgPHJvdz4KLS0gCjIuMjAu MQoK --85da15886f224e1e8ed17aba9728d1aa--