Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum
Date
Msg-id 1F345CC7-6A59-4324-B6D2-BDC80B96182F@elevated-dev.com
Whole thread Raw
In response to Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
> On May 9, 2024, at 8:49 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
>
> Why?  RECREATE TABLE says exactly what it does: recreates the table, and doesn't pretend to do something it doesn't
do(vacuum the table). 

The current method is just one alternative to implement the goal: removing all dead tuples. Exposing the implementation
detailin the command name is not really any kind of improvement, IMO. 




pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum
Next
From: Laurenz Albe
Date:
Subject: Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum