Message-ID: <962fbfac0c3e10b418d8ddfcf4109360d0cce380.camel@cybertec.at>
Subject: Re: Remove recommendation for nightly VACUUM
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Magnus Hagander <magnus@hagander.net>
Cc: pgsql-docs@postgresql.org
Date: Mon, 27 Jun 2022 10:52:19 +0200
In-Reply-To: 
 <CABUevEwd62BRCFje5LpmEioQ7sA=2zwa7h-_EfU7X0VbwQcRtw@mail.gmail.com>
References: <6f5e3da98fec14640f389d7b84c3b413833697f4.camel@cybertec.at>
	 <CABUevEwd62BRCFje5LpmEioQ7sA=2zwa7h-_EfU7X0VbwQcRtw@mail.gmail.com>
Content-Type: multipart/mixed; boundary="=-RSRjBXRJl3jzm6OWDYFx"
User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/962fbfac0c3e10b418d8ddfcf4109360d0cce380.camel%40cybertec.at>
Precedence: bulk


--=-RSRjBXRJl3jzm6OWDYFx
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

On Mon, 2022-06-27 at 10:31 +0200, Magnus Hagander wrote:
> On Mon, Jun 27, 2022 at 8:31 AM Laurenz Albe <laurenz.albe@cybertec.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


--=-RSRjBXRJl3jzm6OWDYFx
Content-Disposition: attachment;
	filename*0=0001-Remove-outdated-recommendation-for-manual-VACUUM.V2.patc;
	filename*1=h
Content-Transfer-Encoding: base64
Content-Type: text/x-patch;
	name="0001-Remove-outdated-recommendation-for-manual-VACUUM.V2.patch";
	charset="UTF-8"

RnJvbSAxZjJkZDc5M2E1MjJlOGUxNjk3MGQ0MDQyMTI2NGQ1ZGM4YWE1ZTEwIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h
dD4KRGF0ZTogTW9uLCAyNyBKdW4gMjAyMiAxMDo1MDoxMiArMDIwMApTdWJqZWN0OiBbUEFUQ0hd
IFJlbW92ZSBvdXRkYXRlZCByZWNvbW1lbmRhdGlvbiBmb3IgbWFudWFsIFZBQ1VVTQoKV2UgaGF2
ZSBiZWVuIGhhdmluZyBhIHdvcmtpbmcgYW5kIGhpZ2hseSB0dW5hYmxlIGF1dG92YWN1dW0KZm9y
IGF0IGxlYXN0IGEgZGVjYWRlIG5vdywgc28gcmVtb3ZlIHRoZSByZWNvbW1lbmRhdGlvbiB0bwp2
YWN1dW0gdGFibGVzIGF0IGxlYXN0IGV2ZXJ5IG5pZ2h0LgpBdXRvdmFjdXVtIGlzIG5vdyBhbHNv
IHRyaWdnZXJlZCBieSBJTlNFUlRzLCBzbyB3ZSBjYW4gYWxzbwpyZW1vdmUgdGhlIHJlY29tbWVu
ZGF0aW9uIHRvIHJ1biBWQUNVVU0gKEFOQUxZWkUpIGFmdGVyIGxvdHMKb2YgSU5TRVJUcyBvciBE
RUxFVEVzLgoKSW5zdGVhZCwgc3VnZ2VzdCB1c2luZyBhdXRvdmFjdXVtIGJ5IG1vdmluZyB0aGUg
cmVzcGVjdGl2ZQpwYXJhZ3JhcGggdXAgdG8gd2hlcmUgdGhlIGltcG9ydGFuY2Ugb2YgVkFDVVVN
IGlzIGVtcGhhc2l6ZWQuCi0tLQogZG9jL3NyYy9zZ21sL3JlZi92YWN1dW0uc2dtbCB8IDIwICsr
KysrLS0tLS0tLS0tLS0tLS0tCiAxIGZpbGUgY2hhbmdlZCwgNSBpbnNlcnRpb25zKCspLCAxNSBk
ZWxldGlvbnMoLSkKCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvcmVmL3ZhY3V1bS5zZ21sIGIv
ZG9jL3NyYy9zZ21sL3JlZi92YWN1dW0uc2dtbAppbmRleCAzZGYzMmI1OGVlLi5jNTgyMDIxZDI5
IDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvcmVmL3ZhY3V1bS5zZ21sCisrKyBiL2RvYy9zcmMv
c2dtbC9yZWYvdmFjdXVtLnNnbWwKQEAgLTM3NywxNSArMzc3LDExIEBAIFZBQ1VVTSBbIEZVTEwg
XSBbIEZSRUVaRSBdIFsgVkVSQk9TRSBdIFsgQU5BTFlaRSBdIFsgPHJlcGxhY2VhYmxlIGNsYXNz
PSJwYXJhbWV0CiAgICA8L3BhcmE+CiAKICAgIDxwYXJhPgotICAgIFdlIHJlY29tbWVuZCB0aGF0
IGFjdGl2ZSBwcm9kdWN0aW9uIGRhdGFiYXNlcyBiZQotICAgIHZhY3V1bWVkIGZyZXF1ZW50bHkg
KGF0IGxlYXN0IG5pZ2h0bHkpLCBpbiBvcmRlciB0bwotICAgIHJlbW92ZSBkZWFkIHJvd3MuIEFm
dGVyIGFkZGluZyBvciBkZWxldGluZyBhIGxhcmdlIG51bWJlcgotICAgIG9mIHJvd3MsIGl0IG1p
Z2h0IGJlIGEgZ29vZCBpZGVhIHRvIGlzc3VlIGEgPGNvbW1hbmQ+VkFDVVVNCi0gICAgQU5BTFla
RTwvY29tbWFuZD4gY29tbWFuZCBmb3IgdGhlIGFmZmVjdGVkIHRhYmxlLiBUaGlzIHdpbGwgdXBk
YXRlIHRoZQotICAgIHN5c3RlbSBjYXRhbG9ncyB3aXRoCi0gICAgdGhlIHJlc3VsdHMgb2YgYWxs
IHJlY2VudCBjaGFuZ2VzLCBhbmQgYWxsb3cgdGhlCi0gICAgPHByb2R1Y3RuYW1lPlBvc3RncmVT
UUw8L3Byb2R1Y3RuYW1lPiBxdWVyeSBwbGFubmVyIHRvIG1ha2UgYmV0dGVyCi0gICAgY2hvaWNl
cyBpbiBwbGFubmluZyBxdWVyaWVzLgorICAgIFdlIHJlY29tbWVuZCB0aGF0IGFsbCBkYXRhYmFz
ZXMgYmUgdmFjdXVtZWQgcmVndWxhcmx5IGluCisgICAgb3JkZXIgdG8gcmVtb3ZlIGRlYWQgcm93
cy4gIDxwcm9kdWN0bmFtZT5Qb3N0Z3JlU1FMPC9wcm9kdWN0bmFtZT4gaW5jbHVkZXMKKyAgICBh
biA8cXVvdGU+YXV0b3ZhY3V1bTwvcXVvdGU+IGZhY2lsaXR5IHdoaWNoIGNhbiBhdXRvbWF0ZSBy
b3V0aW5lIHZhY3V1bQorICAgIG1haW50ZW5hbmNlLiAgRm9yIG1vcmUgaW5mb3JtYXRpb24gYWJv
dXQgYXV0b21hdGljIGFuZCBtYW51YWwgdmFjdXVtaW5nLAorICAgIHNlZSA8eHJlZiBsaW5rZW5k
PSJyb3V0aW5lLXZhY3V1bWluZyIvPi4KICAgIDwvcGFyYT4KIAogICAgPHBhcmE+CkBAIC00MTIs
MTIgKzQwOCw2IEBAIFZBQ1VVTSBbIEZVTEwgXSBbIEZSRUVaRSBdIFsgVkVSQk9TRSBdIFsgQU5B
TFlaRSBdIFsgPHJlcGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0CiAgICAgZGV0YWlscy4KICAgIDwv
cGFyYT4KIAotICAgPHBhcmE+Ci0gICAgPHByb2R1Y3RuYW1lPlBvc3RncmVTUUw8L3Byb2R1Y3Ru
YW1lPiBpbmNsdWRlcyBhbiA8cXVvdGU+YXV0b3ZhY3V1bTwvcXVvdGU+Ci0gICAgZmFjaWxpdHkg
d2hpY2ggY2FuIGF1dG9tYXRlIHJvdXRpbmUgdmFjdXVtIG1haW50ZW5hbmNlLiAgRm9yIG1vcmUK
LSAgICBpbmZvcm1hdGlvbiBhYm91dCBhdXRvbWF0aWMgYW5kIG1hbnVhbCB2YWN1dW1pbmcsIHNl
ZQotICAgIDx4cmVmIGxpbmtlbmQ9InJvdXRpbmUtdmFjdXVtaW5nIi8+LgotICAgPC9wYXJhPgog
ICAgPHBhcmE+CiAgICAgRWFjaCBiYWNrZW5kIHJ1bm5pbmcgPGNvbW1hbmQ+VkFDVVVNPC9jb21t
YW5kPiB3aXRob3V0IHRoZQogICAgIDxsaXRlcmFsPkZVTEw8L2xpdGVyYWw+IG9wdGlvbiB3aWxs
IHJlcG9ydCBpdHMgcHJvZ3Jlc3MgaW4gdGhlCi0tIAoyLjM1LjMKCg==


--=-RSRjBXRJl3jzm6OWDYFx--