Re: No vacuum for insert-only database?

Поиск
Список
Период
Сортировка
От Craig A. James
Тема Re: No vacuum for insert-only database?
Дата
Msg-id 4415A9A4.5020903@modgraph-usa.com
обсуждение исходный текст
Ответ на Re: No vacuum for insert-only database?  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: No vacuum for insert-only database?  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: No vacuum for insert-only database?  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-performance
Alvaro Herrera wrote:
>>If I only insert data into a table, never update or delete, then I should
>>never have to vacuum it.  Is that correct?
>
> You still need to vacuum eventually, to avoid transaction Id wraparound
> issues.  But not as often.

Thanks.  Any suggestions for what "not as often" means?  For example, if my database will never contain more than 10
millionrows, is that a problem?  100 million rows?  When does transaction ID wraparound become a problem? 

Craig

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: No vacuum for insert-only database?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: No vacuum for insert-only database?