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-09 14:53:50
Message-ID: CANzqJaC0J9c8D=1u+cUKhbeZR0TSurwioqw4Ft0=qyj+X8pnkQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, May 9, 2024 at 10:50 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Thu, May 9, 2024 at 7:21 AM Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
> wrote:
>
>> On Thu, May 9, 2024 at 10:07 AM David G. Johnston <
>> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>>
>>> On Thu, May 9, 2024 at 6:58 AM Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
>>> wrote:
>>>
>>>>
>>>> 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.
>>>>
>>>>
>>> I think there is general agreement here but your cure is arguably worse
>>> than the disease.
>>>
>>
>> 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).
>>
>>
> That's distracting from the question at hand, which is whether and how to
> go about changing this, not whether the alternative naming is better than
> the existing one. It isn't so much better that the pain of change seems
> worth it. Mostly because it isn't like the universe simply gets
> reprogrammed to map the old onto the new, and having the old and new
> co-exist produces a burden.
>

I requested a feature from an open source project. The appropriate
response when Those Doing The Work don't want to do that work is "we don't
want to expend the effort on that".

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2024-05-09 15:12:31 Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum
Previous Message David G. Johnston 2024-05-09 14:49:48 Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum