Postgres Pro
Downloads
Home   >   mailing lists

Re: How can i be certain autovacuum is causing reuse if table still grows - Mailing list pgsql-admin

From Keith Fiske
Subject Re: How can i be certain autovacuum is causing reuse if table still grows
Date
Msg-id CAODZiv6PAs=AuqgJH4O-r3A7TmfkHjc168omVeWKiAoiuDf6fg@mail.gmail.com
Whole thread Raw
In response to Re: How can i be certain autovacuum is causing reuse if table still grows  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: How can i be certain autovacuum is causing reuse if table still grows  (MichaelDBA <MichaelDBA@sqlexec.com>)
List pgsql-admin
Tree view


On Tue, Aug 4, 2020 at 3:54 PM Scott Ribe <scott_ribe@elevated-dev.com> wrote:
> On Aug 4, 2020, at 12:31 PM, Sidney Aloisio Ferreira Pryor <sidney@tjrj.jus.br> wrote:
>
> Beside this, i saw on pg_stat_tables and the vacuum and autovacuum count for this table is 0.

Those values are not persistent; they are only since the last start of PG.


This is not correct. Statistics are persistent through restarts. They are only reset during specific cases such as a crash or a major version upgrade. They can also be reset at any time manually.

--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com

pgsql-admin by date:

Previous
From: Sidney Aloisio Ferreira Pryor
Date:
Subject: RE: How can i be certain autovacuum is causing reuse if table still grows
Next
From: MichaelDBA
Date:
Subject: Re: How can i be certain autovacuum is causing reuse if table still grows