Re: Remove recommendation for nightly VACUUM

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: Remove recommendation for nightly VACUUM
Date: 2022-06-27 08:52:19
Message-ID: 962fbfac0c3e10b418d8ddfcf4109360d0cce380.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Mon, 2022-06-27 at 10:31 +0200, Magnus Hagander wrote:
> On Mon, Jun 27, 2022 at 8:31 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
> > A customer recently pointed me to
> > https://www.postgresql.org/docs/current/sql-vacuum.html
> > and asked if I agree with the statement there that a nightly
> > scheduled VACUUM were a good idea:
>
> Agred. A nightly vacuum is definitely not something for "most people" anymore.
>
> But also. "active production databases". Surely we recommend regular vacuum in *all*
> databases when it's primarily driven by autovacuum? At least all active. But
> there's nothing special about "production"? Since we're tweaking the wording,
> I would suggest removing that reference as well.

You are right. Done in the attached.

Yours,
Laurenz Albe

Attachment Content-Type Size
0001-Remove-outdated-recommendation-for-manual-VACUUM.V2.patch text/x-patch 2.4 KB

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Geoghegan 2022-06-27 15:35:35 Re: Remove recommendation for nightly VACUUM
Previous Message Alvaro Herrera 2022-06-27 08:48:39 Re: proposal: convert comments in documents to html comments