Re: Vacuum, Freeze and Analyze: the big picture

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Vacuum, Freeze and Analyze: the big picture
Дата
Msg-id 51A7A605.3050700@agliodbs.com
обсуждение исходный текст
Ответ на Vacuum, Freeze and Analyze: the big picture  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Vacuum, Freeze and Analyze: the big picture
Список pgsql-hackers
> If we have reason to vacuum the relation we do it at
> vacuum_freeze_table_age, not only at autovacuum_max_freeze_age. The
> difference is that the latter triggers a vacuum, while the former only
> changes a partial vacuum into a full one.
> 
> Calling that behaviour unconditionally worse is, err, interesting...

*overall* it's better.  But as far as FREEZE itself is concerned, it's
worse.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Vacuum, Freeze and Analyze: the big picture
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Freezing without write I/O