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 1loMzb-0007T6-2I for pgsql-docs@arkaria.postgresql.org; Wed, 02 Jun 2021 09:16:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1loMzZ-0000Ix-VP for pgsql-docs@arkaria.postgresql.org; Wed, 02 Jun 2021 09:16:49 +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 1loMzZ-0000Io-ND for pgsql-docs@lists.postgresql.org; Wed, 02 Jun 2021 09:16:49 +0000 Received: from mail-pj1-x1033.google.com ([2607:f8b0:4864:20::1033]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1loMzX-0006CR-4g for pgsql-docs@lists.postgresql.org; Wed, 02 Jun 2021 09:16:49 +0000 Received: by mail-pj1-x1033.google.com with SMTP id k22-20020a17090aef16b0290163512accedso1305290pjz.0 for ; Wed, 02 Jun 2021 02:16:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc:content-transfer-encoding; bh=SIVyTay/ck7gRlwqUmRbFBLvABhxjNg6CREYOFcb2dQ=; b=AkvTVO1pdxx2KESznyo7n3Na+ZnCRUMNQn06Dg4PAX+On9bgchC0Gspqx4CP1x3H/N 5GpldwAtYzFzn+9emgUqbqbAqV7BjYIx3d7SbsC9fgBQz3CMjNHgNY72Ee0Z4VHTkvWg 0PI9WjReIZ1KV6v+ZwI1RTjyPfKzdl+o3oK/839xyNPTaXUPbqcpL3xbknUrzVxFxE5l 9nbMXBoyipxZBTC5bCu1ueW3nbAeYuMk+/dzrVeyK39vffMPA+c9OcHQWQhvx0/tWHac kalTi5SRp6x14JLESALzn27lDXQTl6Qb9wYxP02PAHTvY7+0byEYuDXkQWhcM7zKHPL8 wF5Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc:content-transfer-encoding; bh=SIVyTay/ck7gRlwqUmRbFBLvABhxjNg6CREYOFcb2dQ=; b=Rp/r5TvH3Ls0punN6x8Uwk+/6n5trGWLkSyAyHKf3pk0ZtI3uDiVR0tv2kgpMLfTx2 Cnp5OMqFaaSLeU6HxASygh3GZwk4wbzUDwCUv2BLFP3uS7hxETeeKa1K0GAJdZlE4Kzf KjUEY0cLJstA0l8wH6TnFmnyjs3RD0ADCtevUiJTDyGFbggizgGmoIMUwUlIVV2Aruu1 71N9UyxQrI2qQIotEGDCvJNa7oaexaRisC2XqMkMNxeE1B3z9ISsb3bNf5gZ2tCElfU4 kyoY6uCEWaeUxIGnmyoXKFlPVnHopbwiJwZJj1exq76CDJJ1WUehM6xRa9PtlWHMoXwg 4FBQ== X-Gm-Message-State: AOAM531v656l3WYl6UL/WCOWFiJWJ8r/kXP7msSQnJSES948kMPgea4z 2HvV7Q2YJht3p7CGLRh3YzKU5HHMlTebMpJrgGo= X-Google-Smtp-Source: ABdhPJydn+TnM92ww7l7C4T1ZIMoQId5PYQxqp+075/vwka5sC6Tt59NFGyZvULK2Evyl0WpZBodpLNkCYBUegaH4AQ= X-Received: by 2002:a17:902:7792:b029:fc:e490:ff9f with SMTP id o18-20020a1709027792b02900fce490ff9fmr29877761pll.27.1622625404881; Wed, 02 Jun 2021 02:16:44 -0700 (PDT) MIME-Version: 1.0 References: <1c6fa18692a77ff6098dedc0c150df24ffe9db89.camel@cybertec.at> In-Reply-To: <1c6fa18692a77ff6098dedc0c150df24ffe9db89.camel@cybertec.at> From: Masahiko Sawada Date: Wed, 2 Jun 2021 18:16:08 +0900 Message-ID: Subject: Re: Update maintenance_work_mem/autovacuum_work_mem to reflect the 1GB limitation with VACUUM To: Laurenz Albe Cc: =?UTF-8?B?TWFydMOtbiBNYXJxdcOpcw==?= , pgsql-docs@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, May 5, 2021 at 7:03 PM Laurenz Albe wrot= e: > > On Mon, 2021-05-03 at 13:48 -0300, Mart=C3=ADn Marqu=C3=A9s 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? Regards, --=20 Masahiko Sawada EDB: https://www.enterprisedb.com/