Thread: Frequency of pg_stat_all_tables updating?

From

Wells Oliver

Date:

14 May 2023, 03:54:26

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?

From

"David G. Johnston"

Date:

14 May 2023, 04:09:37

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.