Message-ID: <6f5e3da98fec14640f389d7b84c3b413833697f4.camel@cybertec.at>
Subject: Remove recommendation for nightly VACUUM
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: pgsql-docs@postgresql.org
Date: Mon, 27 Jun 2022 08:31:46 +0200
Content-Type: multipart/mixed; boundary="=-m0F481muS6GlXt08pArg"
User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/6f5e3da98fec14640f389d7b84c3b413833697f4.camel%40cybertec.at>
Precedence: bulk


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

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:

"We recommend that active production databases be vacuumed frequently
 (at least nightly), in order to remove dead rows. After adding or
 deleting a large number of rows, it might be a good idea to issue a
 VACUUM ANALYZE command for the affected table. This will update the
 system catalogs with the results of all recent changes, and allow the
 PostgreSQL query planner to make better choices in planning queries."

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.

Yours,
Laurenz Albe

--=-m0F481muS6GlXt08pArg
Content-Disposition: attachment;
	filename="0001-Remove-outdated-recommendation-for-manual-VACUUM.patch"
Content-Type: text/x-patch;
	name="0001-Remove-outdated-recommendation-for-manual-VACUUM.patch";
	charset="UTF-8"
Content-Transfer-Encoding: base64

RnJvbSBlZmQzYzQwODBjNDhiZDhjMzUxMmZiN2Y2YTIxNWZlOTZhMzkxMmNlIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h
dD4KRGF0ZTogTW9uLCAyNyBKdW4gMjAyMiAwODoyNTowNyArMDIwMApTdWJqZWN0OiBbUEFUQ0hd
IFJlbW92ZSBvdXRkYXRlZCByZWNvbW1lbmRhdGlvbiBmb3IgbWFudWFsIFZBQ1VVTQoKV2UgaGF2
ZSBiZWVuIGhhdmluZyBhIHdvcmtpbmcgYW5kIGhpZ2hseSB0dW5hYmxlIGF1dG92YWN1dW0KZm9y
IGF0IGxlYXN0IGEgZGVjYWRlIG5vdywgc28gcmVtb3ZlIHRoZSByZWNvbW1lbmRhdGlvbiB0bwp2
YWN1dW0gdGFibGVzIGF0IGxlYXN0IGV2ZXJ5IG5pZ2h0LgpBdXRvdmFjdXVtIGlzIG5vdyBhbHNv
IHRyaWdnZXJlZCBieSBJTlNFUlRzLCBzbyB3ZSBjYW4gYWxzbwpyZW1vdmUgdGhlIHJlY29tbWVu
ZGF0aW9uIHRvIHJ1biBWQUNVVU0gKEFOQUxZWkUpIGFmdGVyIGxvdHMKb2YgSU5TRVJUcyBvciBE
RUxFVEVzLgoKSW5zdGVhZCwgc3VnZ2VzdCB1c2luZyBhdXRvdmFjdXVtIGJ5IG1vdmluZyB0aGUg
cmVzcGVjdGl2ZQpwYXJhZ3JhcGggdXAgdG8gd2hlcmUgdGhlIGltcG9ydGFuY2Ugb2YgVkFDVVVN
IGlzIGVtcGhhc2l6ZWQuCi0tLQogZG9jL3NyYy9zZ21sL3JlZi92YWN1dW0uc2dtbCB8IDIwICsr
KysrLS0tLS0tLS0tLS0tLS0tCiAxIGZpbGUgY2hhbmdlZCwgNSBpbnNlcnRpb25zKCspLCAxNSBk
ZWxldGlvbnMoLSkKCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvcmVmL3ZhY3V1bS5zZ21sIGIv
ZG9jL3NyYy9zZ21sL3JlZi92YWN1dW0uc2dtbAppbmRleCAzZGYzMmI1OGVlLi42OGM0NDUwYzI5
IDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvcmVmL3ZhY3V1bS5zZ21sCisrKyBiL2RvYy9zcmMv
c2dtbC9yZWYvdmFjdXVtLnNnbWwKQEAgLTM3NywxNSArMzc3LDExIEBAIFZBQ1VVTSBbIEZVTEwg
XSBbIEZSRUVaRSBdIFsgVkVSQk9TRSBdIFsgQU5BTFlaRSBdIFsgPHJlcGxhY2VhYmxlIGNsYXNz
PSJwYXJhbWV0CiAgICA8L3BhcmE+CiAKICAgIDxwYXJhPgotICAgIFdlIHJlY29tbWVuZCB0aGF0
IGFjdGl2ZSBwcm9kdWN0aW9uIGRhdGFiYXNlcyBiZQotICAgIHZhY3V1bWVkIGZyZXF1ZW50bHkg
KGF0IGxlYXN0IG5pZ2h0bHkpLCBpbiBvcmRlciB0bwotICAgIHJlbW92ZSBkZWFkIHJvd3MuIEFm
dGVyIGFkZGluZyBvciBkZWxldGluZyBhIGxhcmdlIG51bWJlcgotICAgIG9mIHJvd3MsIGl0IG1p
Z2h0IGJlIGEgZ29vZCBpZGVhIHRvIGlzc3VlIGEgPGNvbW1hbmQ+VkFDVVVNCi0gICAgQU5BTFla
RTwvY29tbWFuZD4gY29tbWFuZCBmb3IgdGhlIGFmZmVjdGVkIHRhYmxlLiBUaGlzIHdpbGwgdXBk
YXRlIHRoZQotICAgIHN5c3RlbSBjYXRhbG9ncyB3aXRoCi0gICAgdGhlIHJlc3VsdHMgb2YgYWxs
IHJlY2VudCBjaGFuZ2VzLCBhbmQgYWxsb3cgdGhlCi0gICAgPHByb2R1Y3RuYW1lPlBvc3RncmVT
UUw8L3Byb2R1Y3RuYW1lPiBxdWVyeSBwbGFubmVyIHRvIG1ha2UgYmV0dGVyCi0gICAgY2hvaWNl
cyBpbiBwbGFubmluZyBxdWVyaWVzLgorICAgIFdlIHJlY29tbWVuZCB0aGF0IGFjdGl2ZSBwcm9k
dWN0aW9uIGRhdGFiYXNlcyBiZSB2YWN1dW1lZCByZWd1bGFybHkgaW4KKyAgICBvcmRlciB0byBy
ZW1vdmUgZGVhZCByb3dzLiAgPHByb2R1Y3RuYW1lPlBvc3RncmVTUUw8L3Byb2R1Y3RuYW1lPiBp
bmNsdWRlcworICAgIGFuIDxxdW90ZT5hdXRvdmFjdXVtPC9xdW90ZT4gZmFjaWxpdHkgd2hpY2gg
Y2FuIGF1dG9tYXRlIHJvdXRpbmUgdmFjdXVtCisgICAgbWFpbnRlbmFuY2UuICBGb3IgbW9yZSBp
bmZvcm1hdGlvbiBhYm91dCBhdXRvbWF0aWMgYW5kIG1hbnVhbCB2YWN1dW1pbmcsCisgICAgc2Vl
IDx4cmVmIGxpbmtlbmQ9InJvdXRpbmUtdmFjdXVtaW5nIi8+LgogICAgPC9wYXJhPgogCiAgICA8
cGFyYT4KQEAgLTQxMiwxMiArNDA4LDYgQEAgVkFDVVVNIFsgRlVMTCBdIFsgRlJFRVpFIF0gWyBW
RVJCT1NFIF0gWyBBTkFMWVpFIF0gWyA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXQKICAgICBk
ZXRhaWxzLgogICAgPC9wYXJhPgogCi0gICA8cGFyYT4KLSAgICA8cHJvZHVjdG5hbWU+UG9zdGdy
ZVNRTDwvcHJvZHVjdG5hbWU+IGluY2x1ZGVzIGFuIDxxdW90ZT5hdXRvdmFjdXVtPC9xdW90ZT4K
LSAgICBmYWNpbGl0eSB3aGljaCBjYW4gYXV0b21hdGUgcm91dGluZSB2YWN1dW0gbWFpbnRlbmFu
Y2UuICBGb3IgbW9yZQotICAgIGluZm9ybWF0aW9uIGFib3V0IGF1dG9tYXRpYyBhbmQgbWFudWFs
IHZhY3V1bWluZywgc2VlCi0gICAgPHhyZWYgbGlua2VuZD0icm91dGluZS12YWN1dW1pbmciLz4u
Ci0gICA8L3BhcmE+CiAgICA8cGFyYT4KICAgICBFYWNoIGJhY2tlbmQgcnVubmluZyA8Y29tbWFu
ZD5WQUNVVU08L2NvbW1hbmQ+IHdpdGhvdXQgdGhlCiAgICAgPGxpdGVyYWw+RlVMTDwvbGl0ZXJh
bD4gb3B0aW9uIHdpbGwgcmVwb3J0IGl0cyBwcm9ncmVzcyBpbiB0aGUKLS0gCjIuMzUuMwoK


--=-m0F481muS6GlXt08pArg--