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

Поиск
Список
Период
Сортировка
От Sidney Aloisio Ferreira Pryor
Тема RE: How can i be certain autovacuum is causing reuse if table still grows
Дата
Msg-id CP2PR80MB0707C6B3F7D02A41174E04538C4A0@CP2PR80MB0707.lamprd80.prod.outlook.com
обсуждение исходный текст
Ответ на Re: How can i be certain autovacuum is causing reuse if table still grows  (Scott Ribe <scott_ribe@elevated-dev.com>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: How can i be certain autovacuum is causing reuse if table still grows
Следующее
От: Keith Fiske
Дата:
Сообщение: Re: How can i be certain autovacuum is causing reuse if table still grows