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

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum
Дата
Msg-id CANzqJaBzVjiMBTQduOP+S5bOhJSarxqR12Nf=9W1uqsoBvebLQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum  (Nikolay Samokhvalov <samokhvalov@gmail.com>)
Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum  (Rui DeSousa <rui.desousa@icloud.com>)
Список pgsql-admin
Дерево обсуждения
On Thu, May 9, 2024 at 4:11 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Thu, 2024-05-09 at 09:58 -0400, Ron Johnson wrote:
> Because vacuum is vacuum.

The problem is that the two commands do something different, so it
would be misleading.  Renaming VACUUM (FULL) is a good idea in principle,
but I think that is more than 10 years too late.  The compatibility
break would be too painful.

Make VACUUM (FULL) a synonym for RECREATE TABLE, then say in the docs that VACUUM (FULL) is deprecated.
 
Then drop it in PG 27...

Perhaps you could write a patch to add a column "last_rewritten"
to "pg_stat_all_tables"...

I'm a worse C programmer than I am a DBA. 
 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum
Следующее
От: Rui DeSousa
Дата:
Сообщение: Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum