Re: pgsql: Remove outdated recommendation for manual VACUUM

2022-06-27 Thread Bruce Momjian
On Mon, Jun 27, 2022 at 09:27:29PM +0200, Magnus Hagander wrote: > Uh, shouldn't this doc patch be applied to all major supported Postgres > versions? > > Not sure. If we do we'd at least have to adapt it past the point where > autovacuum handles INSERTs I think? Oh, good point, never mind

Re: pgsql: Remove outdated recommendation for manual VACUUM

2022-06-27 Thread Magnus Hagander
On Mon, Jun 27, 2022 at 8:57 PM Bruce Momjian wrote: > On Mon, Jun 27, 2022 at 05:48:41PM +, Magnus Hagander wrote: > > Remove outdated recommendation for manual VACUUM > > > > We have had a working and tunable autovacuum > > for at least a decade now, so remove the recommendation to > > manu

Re: pgsql: Remove outdated recommendation for manual VACUUM

2022-06-27 Thread Bruce Momjian
On Mon, Jun 27, 2022 at 05:48:41PM +, Magnus Hagander wrote: > Remove outdated recommendation for manual VACUUM > > We have had a working and tunable autovacuum > for at least a decade now, so remove the recommendation to > manually vacuum tables at least every night. > Autovacuum is now also

pgsql: Remove outdated recommendation for manual VACUUM

2022-06-27 Thread Magnus Hagander
Remove outdated recommendation for manual VACUUM We have had a working and tunable autovacuum for at least a decade now, so remove the recommendation to manually vacuum tables at least every night. Autovacuum is now also triggered by INSERTs, so we can also remove the recommendation to run VACUUM