Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum
Date: 2024-05-09 13:58:05
Message-ID: CANzqJaBDOrzCsd-hp15ya6JEScgqWYUhN5xUZBsUqZxWv9p6DQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2024-05-09 14:06:25 Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum
Previous Message Kashif Zeeshan 2024-05-09 03:49:51 Re: Locked account