pg.ddx.io pgsql-committers@postgresql.org mailing list archive
help / color / mirror / Atom feedpgsql: Remove outdated recommendation for manual VACUUM
4+ messages / 2 participants
[nested] [flat]
* pgsql: Remove outdated recommendation for manual VACUUM
@ 2022-06-27 17:48 Magnus Hagander <magnus@hagander.net>
0 siblings, 1 reply; 4+ messages in thread
From: Magnus Hagander @ 2022-06-27 17:48 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
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 (ANALYZE) after lots
of INSERTs or DELETEs.
Instead, suggest using autovacuum by moving the respective
paragraph up to where the importance of VACUUM is emphasized.
Author: Laurenz Albe <laurenz.albe@cybertec.at>
Reviewed-By: Magnus Hagander, Peter Geoghegan
Discussion: https://postgr.es/m/6f5e3da98fec14640f389d7b84c3b413833697f4.camel@cybertec.at
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/27f953ea9901c08fb3e4064f9a31e07bc30c1e6d
Modified Files
--------------
doc/src/sgml/ref/vacuum.sgml | 20 +++++---------------
1 file changed, 5 insertions(+), 15 deletions(-)
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pgsql: Remove outdated recommendation for manual VACUUM
@ 2022-06-27 18:57 Bruce Momjian <bruce@momjian.us>
parent: Magnus Hagander <magnus@hagander.net>
0 siblings, 1 reply; 4+ messages in thread
From: Bruce Momjian @ 2022-06-27 18:57 UTC (permalink / raw)
To: Magnus Hagander <magnus@hagander.net>; +Cc: pgsql-committers@lists.postgresql.org
On Mon, Jun 27, 2022 at 05:48:41PM +0000, 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 triggered by INSERTs, so we can also
> remove the recommendation to run VACUUM (ANALYZE) after lots
> of INSERTs or DELETEs.
>
> Instead, suggest using autovacuum by moving the respective
> paragraph up to where the importance of VACUUM is emphasized.
>
> Author: Laurenz Albe <laurenz.albe@cybertec.at>
> Reviewed-By: Magnus Hagander, Peter Geoghegan
> Discussion: https://postgr.es/m/6f5e3da98fec14640f389d7b84c3b413833697f4.camel@cybertec.at
>
> Branch
> ------
> master
>
> Details
> -------
> https://git.postgresql.org/pg/commitdiff/27f953ea9901c08fb3e4064f9a31e07bc30c1e6d
>
> Modified Files
> --------------
> doc/src/sgml/ref/vacuum.sgml | 20 +++++---------------
> 1 file changed, 5 insertions(+), 15 deletions(-)
Uh, shouldn't this doc patch be applied to all major supported Postgres
versions?
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Indecision is a decision. Inaction is an action. Mark Batterson
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pgsql: Remove outdated recommendation for manual VACUUM
@ 2022-06-27 19:27 Magnus Hagander <magnus@hagander.net>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 4+ messages in thread
From: Magnus Hagander @ 2022-06-27 19:27 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-committers@lists.postgresql.org
On Mon, Jun 27, 2022 at 8:57 PM Bruce Momjian <bruce@momjian.us> wrote:
> On Mon, Jun 27, 2022 at 05:48:41PM +0000, 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 triggered by INSERTs, so we can also
> > remove the recommendation to run VACUUM (ANALYZE) after lots
> > of INSERTs or DELETEs.
> >
> > Instead, suggest using autovacuum by moving the respective
> > paragraph up to where the importance of VACUUM is emphasized.
> >
> > Author: Laurenz Albe <laurenz.albe@cybertec.at>
> > Reviewed-By: Magnus Hagander, Peter Geoghegan
> > Discussion:
> https://postgr.es/m/6f5e3da98fec14640f389d7b84c3b413833697f4.camel@cybertec.at
> >
> > Branch
> > ------
> > master
> >
> > Details
> > -------
> >
> https://git.postgresql.org/pg/commitdiff/27f953ea9901c08fb3e4064f9a31e07bc30c1e6d
> >
> > Modified Files
> > --------------
> > doc/src/sgml/ref/vacuum.sgml | 20 +++++---------------
> > 1 file changed, 5 insertions(+), 15 deletions(-)
>
> 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?
//Magnus
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pgsql: Remove outdated recommendation for manual VACUUM
@ 2022-06-27 19:38 Bruce Momjian <bruce@momjian.us>
parent: Magnus Hagander <magnus@hagander.net>
0 siblings, 0 replies; 4+ messages in thread
From: Bruce Momjian @ 2022-06-27 19:38 UTC (permalink / raw)
To: Magnus Hagander <magnus@hagander.net>; +Cc: pgsql-committers@lists.postgresql.org
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.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Indecision is a decision. Inaction is an action. Mark Batterson
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2022-06-27 19:38 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-06-27 17:48 pgsql: Remove outdated recommendation for manual VACUUM Magnus Hagander <magnus@hagander.net>
2022-06-27 18:57 ` Bruce Momjian <bruce@momjian.us>
2022-06-27 19:27 ` Magnus Hagander <magnus@hagander.net>
2022-06-27 19:38 ` Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox