Is it ever necessary to vacuum a table that only gets inserts/updates?

Поиск
Список
Период
Сортировка
От Jason Buberel
Тема Is it ever necessary to vacuum a table that only gets inserts/updates?
Дата
Msg-id CAAPEApFu5M29GiFJcuJK27OymxAJawfsffMhORdcfznJWsht7Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Is it ever necessary to vacuum a table that only gets inserts/updates?  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
Дерево обсуждения
Just wondering if there is ever a reason to vacuum a very large table (> 1B rows) containing rows that never has rows deleted.

Under what circumstance would the table benefit from a vacuum?

-jason

--
Jason L. Buberel
CTO, Altos Research
http://www.altosresearch.com/
650.603.0907

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

Предыдущее
От: sunpeng
Дата:
Сообщение: hi, firends, what's the difference between using PostgreSQL's share buffer and os's file buffer?
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Is it ever necessary to vacuum a table that only gets inserts/updates?