Re: 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: Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum
Date: 2024-05-10 11:53:06
Message-ID: CANzqJaC0Eev08o8nfG+AzV1UYDvC3Atm3TbnaHGx9mK2A2YT5A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, May 10, 2024 at 7:21 AM Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
wrote:

> On 2024-May-09, Nikolay Samokhvalov wrote:
>
> > With RECREATE TABLE, one day, we would be probably have RECREATE TABLE
> > CONCURRENTLY implemented, making pg_repack less needed.
>
> If we really wanted to rename VACUUM FULL, I would go for a name that
> betrays its CLUSTER implementation -- maybe CLUSTER UNSORTED or so --
>

I considered that, for the same reason. But there's no such thing as an
unsorted CLUSTER, since the whole purpose of CLUSTER is to sort the data.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Philippe Strauss 2024-05-10 12:00:45 syntax error at or near "gist_trgm_ops" on debian
Previous Message Srinivasarao Oguri 2024-05-10 11:35:43 Re: PostgreSQL on netapp AFF C250A storage ?