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

From Ron Johnson
Subject Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum
Date
Msg-id CANzqJaBDOrzCsd-hp15ya6JEScgqWYUhN5xUZBsUqZxWv9p6DQ@mail.gmail.com
Whole thread Raw
Responses Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum
Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum
List pgsql-admin
Because vacuum is vacuum.  Or rename VACUUM FULL to something else, so that no one can reasonably assume that:
1) a command with VACUUM in the name should update the last_vacuumed field, or that
2) VACUUM FULL should be done often, since FULL is seemingly better than not full.

Proposed new name: RECREATE TABLE <table_name> [ USING <index_name> ];

The USING clause added since CLUSTER is really a sorted VACUUM FULL, 

I'm not wedded to the name RECREATE TABLE, but am wedded to the fact that VACUUM FULL is a horrible name for what it does.

pgsql-admin by date:

Previous
From: Kashif Zeeshan
Date:
Subject: Re: Locked account
Next
From: "David G. Johnston"
Date:
Subject: Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum