Re: No vacuum for insert-only database?

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: No vacuum for insert-only database?
Дата
Msg-id 20060313185208.GA5558@wolff.to
обсуждение исходный текст
Ответ на Re: No vacuum for insert-only database?  ("Craig A. James" <cjames@modgraph-usa.com>)
Список pgsql-performance
On Mon, Mar 13, 2006 at 09:19:32 -0800,
  "Craig A. James" <cjames@modgraph-usa.com> wrote:
> 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 million rows, is that a problem?
> 100 million rows?  When does transaction ID wraparound become a problem?

I believe it is at billion (10^9).

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

Предыдущее
От: "andremachado"
Дата:
Сообщение: firebird X postgresql 8.1.2 windows, performance comparison
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: firebird X postgresql 8.1.2 windows, performance comparison