Quick Links

Re: How can i be certain autovacuum is causing reuse if table still grows

From:	Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To:	Sidney Aloisio Ferreira Pryor <sidney(at)tjrj(dot)jus(dot)br>
Cc:	Keith Fiske <keith(dot)fiske(at)crunchydata(dot)com>, Guillaume Lelarge <guillaume(at)lelarge(dot)info>, Ron <ronljohnsonjr(at)gmail(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject:	Re: How can i be certain autovacuum is causing reuse if table still grows
Date:	2020-08-04 19:53:58
Message-ID:	FBBB8A4B-C5F9-4A44-924A-043AEA0D6D02@elevated-dev.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin

> On Aug 4, 2020, at 12:31 PM, Sidney Aloisio Ferreira Pryor <sidney(at)tjrj(dot)jus(dot)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.

In response to

RE: How can i be certain autovacuum is causing reuse if table still grows at 2020-08-04 18:31:16 from Sidney Aloisio Ferreira Pryor

Responses

RE: How can i be certain autovacuum is causing reuse if table still grows at 2020-08-04 20:12:56 from Sidney Aloisio Ferreira Pryor
Re: How can i be certain autovacuum is causing reuse if table still grows at 2020-08-04 22:25:38 from Keith Fiske

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Sidney Aloisio Ferreira Pryor	2020-08-04 20:12:56	RE: How can i be certain autovacuum is causing reuse if table still grows
Previous Message	Sidney Aloisio Ferreira Pryor	2020-08-04 18:31:16	RE: How can i be certain autovacuum is causing reuse if table still grows