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 |
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 |