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 Sidney Aloisio Ferreira Pryor
Subject RE: How can i be certain autovacuum is causing reuse if table still grows
Date
Msg-id CP2PR80MB0707C6B3F7D02A41174E04538C4A0@CP2PR80MB0707.lamprd80.prod.outlook.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>)
List pgsql-admin
Tree view
Thank you Scott.
Sorry for that. Did not attempted it is a view.

De: Scott Ribe <scott_ribe@elevated-dev.com>
Enviado: terça-feira, 4 de agosto de 2020 16:53
Para: Sidney Aloisio Ferreira Pryor <sidney@tjrj.jus.br>
Cc: Keith Fiske <keith.fiske@crunchydata.com>; Guillaume Lelarge <guillaume@lelarge.info>; Ron <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Assunto: Re: How can i be certain autovacuum is causing reuse if table still grows
 
> 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.

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: How can i be certain autovacuum is causing reuse if table still grows
Next
From: Keith Fiske
Date:
Subject: Re: How can i be certain autovacuum is causing reuse if table still grows