Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum
Date: 2024-05-09 15:12:31
Message-ID: 1F345CC7-6A59-4324-B6D2-BDC80B96182F@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On May 9, 2024, at 8:49 AM, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)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 detail in the command name is not really any kind of improvement, IMO.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2024-05-09 20:11:55 Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum
Previous Message Ron Johnson 2024-05-09 14:53:50 Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum