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 1leENC-0003o4-53 for pgsql-docs@arkaria.postgresql.org; Wed, 05 May 2021 10:03:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1leENA-00064B-V2 for pgsql-docs@arkaria.postgresql.org; Wed, 05 May 2021 10:03:16 +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 1leENA-000643-Ot for pgsql-docs@lists.postgresql.org; Wed, 05 May 2021 10:03:16 +0000 Received: from mail-wr1-x434.google.com ([2a00:1450:4864:20::434]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1leEN4-0004wB-FD for pgsql-docs@lists.postgresql.org; Wed, 05 May 2021 10:03:16 +0000 Received: by mail-wr1-x434.google.com with SMTP id l14so1162211wrx.5 for ; Wed, 05 May 2021 03:03:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version; bh=RwcZwNQuej0v8w73i7P+EdeL6IIqyiI7Jt+ymPUay98=; b=oMXy/XmBI6j6O3Sh0j/crF4bS65W/mPXK71XDAXY2OGb3JviHF0Zq3LvylugGi2/ho MEFzQQuKr1RZanGuklUE3qpEszdPM0bwFoI3RphcdEHbERAf10Uq997Aw5sQVYrO6Ryb G7oxhLDAX9EkjUXGGE11AVcdKGcaL1TD7SQTEJx6x1ERzR8x/5Rc6XRE33aie7qAluqI 87DTofGsMn/0jScsjvPJlg8afKUy3EuHWN/RLTCbR1NGb9ey30yqd7WTBV2uYSQL0t7Y 6lzC9irGdJa98rj32QHnPzNy17Al7h9KfAOMYQOv1qRAwNg9uV/x9dXtsinxDj32oR5z 0EFg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version; bh=RwcZwNQuej0v8w73i7P+EdeL6IIqyiI7Jt+ymPUay98=; b=rWfNu222aGpKjpoZ4TYF1MAwOvsAibwfMZT1HDWCDaoXErbDorzS1LGIkZOufuJI1v 0AvfXI5ngfbzVuC2egqlLe3mn3m5kz5m8na8N/guxCgo/ysdIraL+tMxp0DGsPCdSgxL OnZCHFPZpWBY22kP1IrI1igHu8hjY/R2O9gU4JZ00N+yjBzGQg5+PVSkcbGq5egDOvRv sSQpQ1NocnfDMfbpWuCiQmB8uihdoGyneTtIOcY1C3WIBdLbbvIYusGrxCrN+RBi9dWy vGjgNDqQGsFiZOvVHxbyHjuvYYSRjSlaSXwdphqOPDzxvNO4U9OjdtK6/Fc5g7E1xFPv 9tOA== X-Gm-Message-State: AOAM532leKdQ06n8ZopywpIvKLuhaSYWn0YBcZUoV1U5cNTGM8JQOwWR gE+61xwabi2P4QUU7sfqlF2+yA== X-Google-Smtp-Source: ABdhPJxMgPFWyRmLSaBxTyV1On1ee08+w3Tiy9j7qmbzxk5Di7/Bd4DyFWfCyL6J/WmPkOKA3FBl/w== X-Received: by 2002:adf:e845:: with SMTP id d5mr36396926wrn.96.1620208989548; Wed, 05 May 2021 03:03:09 -0700 (PDT) Received: from localhost.localdomain (217-149-168-22.nat.highway.telekom.at. [217.149.168.22]) by smtp.gmail.com with ESMTPSA id h13sm5578343wml.26.2021.05.05.03.03.08 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 05 May 2021 03:03:09 -0700 (PDT) Message-ID: <1c6fa18692a77ff6098dedc0c150df24ffe9db89.camel@cybertec.at> Subject: Re: Update maintenance_work_mem/autovacuum_work_mem to reflect the 1GB limitation with VACUUM From: Laurenz Albe To: =?ISO-8859-1?Q?Mart=EDn_Marqu=E9s?= , pgsql-docs@lists.postgresql.org Date: Wed, 05 May 2021 12:03:08 +0200 In-Reply-To: References: Content-Type: multipart/mixed; boundary="=-/s/K3ecrpMmzcCSdfMt2" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-/s/K3ecrpMmzcCSdfMt2 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit On Mon, 2021-05-03 at 13:48 -0300, Martín Marqués 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, Yours, Laurenz Albe --=-/s/K3ecrpMmzcCSdfMt2 Content-Disposition: attachment; filename="0001-Document-the-1GB-memory-limit-for-VACUUM.patch" Content-Transfer-Encoding: base64 Content-Type: text/x-patch; name="0001-Document-the-1GB-memory-limit-for-VACUUM.patch"; charset="UTF-8" RnJvbSA2OWJhMWY2YmVmMDIwOWZhMTA5M2MzOWJhMmU3MzE2NDFkN2Y1MTg4IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h dD4KRGF0ZTogV2VkLCA1IE1heSAyMDIxIDEyOjAyOjExICswMjAwClN1YmplY3Q6IFtQQVRDSF0g RG9jdW1lbnQgdGhlIDFHQiBtZW1vcnkgbGltaXQgZm9yIFZBQ1VVTQoKLS0tCiBkb2Mvc3JjL3Nn bWwvY29uZmlnLnNnbWwgfCA1ICsrKysrCiAxIGZpbGUgY2hhbmdlZCwgNSBpbnNlcnRpb25zKCsp CgpkaWZmIC0tZ2l0IGEvZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21sIGIvZG9jL3NyYy9zZ21sL2Nv bmZpZy5zZ21sCmluZGV4IDNhMDYyYTE0NWMuLjkyMTliNWM5MGEgMTAwNjQ0Ci0tLSBhL2RvYy9z cmMvc2dtbC9jb25maWcuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvY29uZmlnLnNnbWwKQEAgLTE5 MDEsNiArMTkwMSwxMSBAQCBpbmNsdWRlX2RpciAnY29uZi5kJwogICAgICAgICBiZSB1c2VkIGlu c3RlYWQuICBUaGUgc2V0dGluZyBoYXMgbm8gZWZmZWN0IG9uIHRoZSBiZWhhdmlvciBvZgogICAg ICAgICA8Y29tbWFuZD5WQUNVVU08L2NvbW1hbmQ+IHdoZW4gcnVuIGluIG90aGVyIGNvbnRleHRz LgogICAgICAgIDwvcGFyYT4KKyAgICAgICA8cGFyYT4KKyAgICAgICAgTm9kZSB0aGF0IDxjb21t YW5kPlZBQ1VVTTwvY29tbWFuZD4gaGFzIGEgaGFyZC1jb2RlZCBsaW1pdCBvZiAxR0IKKyAgICAg ICAgZm9yIHRoZSBhbW91bnQgb2YgbWVtb3J5IHVzZWQsIHNvIHNldHRpbmcKKyAgICAgICAgPHZh cm5hbWU+YXV0b3ZhY3V1bV93b3JrX21lbTwvdmFybmFtZT4gaGlnaGVyIHRoYW4gdGhhdCBoYXMg bm8gZWZmZWN0LgorICAgICAgIDwvcGFyYT4KICAgICAgIDwvbGlzdGl0ZW0+CiAgICAgIDwvdmFy bGlzdGVudHJ5PgogCi0tIAoyLjI2LjMKCg== --=-/s/K3ecrpMmzcCSdfMt2--