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
Дата
Msg-id CAODZiv6PAs=AuqgJH4O-r3A7TmfkHjc168omVeWKiAoiuDf6fg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How can i be certain autovacuum is causing reuse if table still grows  (Scott Ribe <scott_ribe@elevated-dev.com>)
Ответы Re: How can i be certain autovacuum is causing reuse if table still grows  (MichaelDBA <MichaelDBA@sqlexec.com>)
Список pgsql-admin
Дерево обсуждения


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 по дате отправления:

Предыдущее
От: Sidney Aloisio Ferreira Pryor
Дата:
Сообщение: RE: How can i be certain autovacuum is causing reuse if table still grows
Следующее
От: MichaelDBA
Дата:
Сообщение: Re: How can i be certain autovacuum is causing reuse if table still grows