Re: VACUUM FULL for performance

Поиск
Список
Период
Сортировка
От Leonardo Francalanci
Тема Re: VACUUM FULL for performance
Дата
Msg-id 888825.2758.qm@web29013.mail.ird.yahoo.com
обсуждение исходный текст
Ответ на Re: VACUUM FULL for performance  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Список pgsql-general
> > MayVACUUM FULL on a  table improve perfromance of the system?
>
> No, it will make things  worse.


???

Why?

"The FULL option is not recommended for routine use, but might be useful
in special cases. An example is when you have deleted or updated most
of the rows in a table and would like the table to physically shrink to
occupy less disk space and allow faster table scans"

This is for 9.0.

For 8.4 I think the indexes on the table could grow; but seq scan on the
table will be faster than with a plain vacuum...




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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Post Install / Secure PostgreSQL
Следующее
От: Szymon Guz
Дата:
Сообщение: Re: VACUUM FULL for performance