Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum
Дата
Msg-id CANzqJaBDOrzCsd-hp15ya6JEScgqWYUhN5xUZBsUqZxWv9p6DQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список 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.

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

Предыдущее
От: Kashif Zeeshan
Дата:
Сообщение: Re: Locked account
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Request for feature: VACUUM FULL updates pg_stat_all_tables.last_vacuum