Обсуждение: Frequency of pg_stat_all_tables updating?

Поиск
Список
Период
Сортировка

Frequency of pg_stat_all_tables updating?

От
Wells Oliver
Дата:
I just ran vacuum full analyze on a table, the # of n_dead_tup is now 0, but the last_vacuum column is still null. What do I make of that?

--

Re: Frequency of pg_stat_all_tables updating?

От
"David G. Johnston"
Дата:
On Saturday, May 13, 2023, Wells Oliver <wells.oliver@gmail.com> wrote:
I just ran vacuum full analyze on a table, the # of n_dead_tup is now 0, but the last_vacuum column is still null. What do I make of that?

The new physical table you created by doing vacuum full has never been vacuumed.

David J.