Postgres Pro
Downloads
Home   >   mailing lists

Re: Frequency of pg_stat_all_tables updating? - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Frequency of pg_stat_all_tables updating?
Date
Msg-id CAKFQuwanm-xgphYMhy1zrqTJY8nZs7iYn7KY40Q_kRFSVeHUzw@mail.gmail.com
Whole thread Raw
In response to Frequency of pg_stat_all_tables updating?  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
Tree view
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. 

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Frequency of pg_stat_all_tables updating?
Next
From: Wells Oliver
Date:
Subject: Options for more aggressive space reclamation in vacuuming?