Re: pg_upgrade —link does it remove table bloat

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: pg_upgrade —link does it remove table bloat
Дата
Msg-id CAHOFxGrWFNwC5B+K7iofDb_49r+JKcXwGZoWyEcQkO66kRSc9w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_upgrade —link does it remove table bloat  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы RE: pg_upgrade —link does it remove table bloat  (Jason Ralph <jralph@affinitysolutions.com>)
Список pgsql-general
There is more than one type of statistics though. Stats on the distribution of data is easily recreated with analyze table_name or analyzing the whole database. What about the stats on how many rows have been inserted or updated since the last (auto)vacuum and that will be used to trigger autovacuum? Are those set back to zero by an upgrade? I would assume usage counts like how many times an index scan has been done would be reset, but if the numbers in pg_stat_user_tables like n_tup_upd or n_tup_del are zero'd out during an upgrade, than it would seem like a manual vacuum would always be a good idea to ensure a table wasn't 99% of the way to needing one and then the stats got reset by upgrading.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_upgrade —link does it remove table bloat
Следующее
От: Jason Ralph
Дата:
Сообщение: RE: pg_upgrade —link does it remove table bloat