Re: pg_stat_progress_vacuum empty when running vacuum full

Поиск
Список
Период
Сортировка
От Ian Lawrence Barwick
Тема Re: pg_stat_progress_vacuum empty when running vacuum full
Дата
Msg-id CAB8KJ=ggE==4UQVPwzOqqEGKQW0tU_c_2uhWh+a6RDZgEpBmNA@mail.gmail.com
обсуждение исходный текст
Ответ на pg_stat_progress_vacuum empty when running vacuum full  (Luca Ferrari <fluca1978@gmail.com>)
Список pgsql-general
2021年2月12日(金) 20:01 Luca Ferrari <fluca1978@gmail.com>:
Hi all,
I'm running 11.5 and I'm monitoring pg_stat_progress_vacuum every 2
seconds, while doing from another connection per-table VACUUMs. Every
vacuum last 30 or more seconds, so I was expecting to see a record
within pg_stat_progress_vacuum, but nothing appears if the vacuum is
full. I suspect this is due to vacuum full performing a side-by-side
table rewriting, rather than in-place actions against the original
table, but I'm not sure if this is real reason or if I'm missing
something.


If you're executing VACUUM FULL, you should be looking at pg_stat_progress_cluster:


Though that doesn't appear until Pg 12.

Regards

Ian Barwick
--

В списке pgsql-general по дате отправления:

Предыдущее
От: Luca Ferrari
Дата:
Сообщение: pg_stat_progress_vacuum empty when running vacuum full
Следующее
От: luis.roberto@siscobra.com.br
Дата:
Сообщение: Re: pg_stat_progress_vacuum empty when running vacuum full