pg_stat_progress_vacuum empty when running vacuum full

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема pg_stat_progress_vacuum empty when running vacuum full
Дата
Msg-id CAKoxK+4+7=DJXT9xL5AwkLNnNFc3zD0e-kO6Ovik=s+AUxPgzw@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_stat_progress_vacuum empty when running vacuum full  (Ian Lawrence Barwick <barwick@gmail.com>)
Re: pg_stat_progress_vacuum empty when running vacuum full  (luis.roberto@siscobra.com.br)
Список pgsql-general
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.

Thanks,
Luca



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

Предыдущее
От: Matthias Apitz
Дата:
Сообщение: kernel.shmmax and kernel.shmall for Linux server
Следующее
От: Ian Lawrence Barwick
Дата:
Сообщение: Re: pg_stat_progress_vacuum empty when running vacuum full