Re: Frequency of pg_stat_all_tables updating?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Frequency of pg_stat_all_tables updating?
Date: 2023-05-14 01:09:37
Message-ID: CAKFQuwanm-xgphYMhy1zrqTJY8nZs7iYn7KY40Q_kRFSVeHUzw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Saturday, May 13, 2023, Wells Oliver <wells(dot)oliver(at)gmail(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2023-05-14 17:45:16 Options for more aggressive space reclamation in vacuuming?
Previous Message Wells Oliver 2023-05-14 00:54:26 Frequency of pg_stat_all_tables updating?