Re: No vacuum for insert-only database?

From: "Craig A(dot) James" <cjames(at)modgraph-usa(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: No vacuum for insert-only database?
Date: 2006-03-13 17:19:32
Message-ID: 4415A9A4.5020903@modgraph-usa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 million rows, is that a problem? 100 million rows? When does transaction ID wraparound become a problem?

Craig

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2006-03-13 17:41:35 Re: No vacuum for insert-only database?
Previous Message Alvaro Herrera 2006-03-13 15:09:49 Re: No vacuum for insert-only database?