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 1o5v0V-0003Tt-De for pgsql-docs@arkaria.postgresql.org; Mon, 27 Jun 2022 20:06: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 1o5v0T-0001Ho-DH for pgsql-docs@arkaria.postgresql.org; Mon, 27 Jun 2022 20:06: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 1o5v0T-0001He-3n for pgsql-docs@lists.postgresql.org; Mon, 27 Jun 2022 20:06:49 +0000 Received: from mail-ed1-x529.google.com ([2a00:1450:4864:20::529]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1o5v0Q-0005Ro-9p for pgsql-docs@postgresql.org; Mon, 27 Jun 2022 20:06:48 +0000 Received: by mail-ed1-x529.google.com with SMTP id o10so14659967edi.1 for ; Mon, 27 Jun 2022 13:06:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=message-id:subject:from:to:cc:date:in-reply-to:references :user-agent:mime-version:content-transfer-encoding; bh=VsGXvXeGn/R7QxItM7rLwWUnjRINXbPjNLih42qO5kY=; b=ONr2bpPE4wDIU7No/7EoVq1i8FujE/2HaEQQ0O9xvPddIqI95Lkx4fburntWIpATMS H78Rfa1xlWN/NDWyzbz22iXWF1qyhB/h4AYsClAdBsejy+8ViEzqlhrVhlDgq5yH9SjU bCicfYqldWtK7bwevZbLtihzkV4H9g5APFWGO9sLb1rWuVtmfrzmX5iUzsbCkLbOUI+o bQMVXQ6e3WJh/Ppjbi5+Ratrx7BeOsQvSK2iogNemgjKzzNFcIMGTWXpuQutCz0HFkhq ZwqAn4x40tN8hhkHCsZzZhvRtgXRCRCLS5CumSVfqX6U9peX8PmARG/VWnt33l+y1ymb mKKA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:subject:from:to:cc:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=VsGXvXeGn/R7QxItM7rLwWUnjRINXbPjNLih42qO5kY=; b=7K0WEUgiGU85MstqiZ2yQ7R40exd9hSd5nt/Y7ymBDiozGmrC5Oh0VjJw7P7BiNDcz QREUMTeRz3/fljlnudjb67Qai7gV/ZLFeRTvheLVXq+QYxTJVhm5a5Cscf22hNRYymBR tO6trab8ZNOTZXZqixcRss3V/vU6UKpwK0CrHq2+P2zeHQqMSnhoR3KIYZpwj5RRkNIw t4TuoGuV4/cqyczO9a0gx9TeqiSkL1Z9VEu3CBa4xGBQoviz0G2Pg2QcYKDtEuPKnqUi q1hSLv3NBYgMstlWOIU2bl4Uii21QonkT3o85XdkAGNg6ooBAhnSY0f+zmCqVTcIme3T 3r3w== X-Gm-Message-State: AJIora/FzAhEwyjoReikFR2kEGDsjY9n1OqlZuiPa/sioeuDunHD8MRv 8Yn9DpB3UDMX58ptzpiQ6rF0UVYDKCXtVA== X-Google-Smtp-Source: AGRyM1sxsiw2WRcOdry7aZpAzzF7SFW0nVWxq/0pM4FZMj5DE8F+OvfDO/j/blYmuQglb8uE8JhUjQ== X-Received: by 2002:aa7:c750:0:b0:435:6113:efcd with SMTP id c16-20020aa7c750000000b004356113efcdmr18628110eds.327.1656360405146; Mon, 27 Jun 2022 13:06:45 -0700 (PDT) Received: from localhost.localdomain (62-46-255-63.adsl.highway.telekom.at. [62.46.255.63]) by smtp.gmail.com with ESMTPSA id w13-20020a170906d20d00b00726298147b1sm5323433ejz.161.2022.06.27.13.06.42 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 27 Jun 2022 13:06:42 -0700 (PDT) Message-ID: <41b6e05c626d04d0e68d1308c280430bc55e6211.camel@cybertec.at> Subject: Re: Remove recommendation for nightly VACUUM From: Laurenz Albe To: Magnus Hagander , Peter Geoghegan Cc: PostgreSQL-documentation Date: Mon, 27 Jun 2022 22:06:42 +0200 In-Reply-To: References: <6f5e3da98fec14640f389d7b84c3b413833697f4.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2022-06-27 at 19:48 +0200, Magnus Hagander wrote: > On Mon, Jun 27, 2022 at 5:36 PM Peter Geoghegan wrote: > > On Mon, Jun 27, 2022 at 1:32 AM Magnus Hagander wrote: > > > > Looking at the Git history, most of that paragraph is from a time > > > > when autovacuum did not yet exist or was much less reliable than it > > > > is now.  So I suggest removing all that and pointing to autovacuum > > > > instead, as done in the attached patch. > > > > > > > > > Agred. A nightly vacuum is definitely not something for "most people" anymore. > > > > +1. > > > > The VACUUM documentation needs to be totally overhauled. This is a start. > > Agred, let's do partial improvement and not wait for a rewrite. Thus, applied! Thanks! Thanks! Laurenz Albe