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 Scott Ribe
Subject Re: How can i be certain autovacuum is causing reuse if table still grows
Date
Msg-id FBBB8A4B-C5F9-4A44-924A-043AEA0D6D02@elevated-dev.com
Whole thread Raw
In response to RE: How can i be certain autovacuum is causing reuse if table still grows  (Sidney Aloisio Ferreira Pryor <sidney@tjrj.jus.br>)
Responses RE: How can i be certain autovacuum is causing reuse if table still grows
Re: How can i be certain autovacuum is causing reuse if table still grows
List pgsql-admin
Tree view 
> 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: Sidney Aloisio Ferreira Pryor
Date:
Subject: RE: How can i be certain autovacuum is causing reuse if table still grows
Next
From: Sidney Aloisio Ferreira Pryor
Date:
Subject: RE: How can i be certain autovacuum is causing reuse if table still grows