On Mon, Mar 13, 2006 at 09:19:32 -0800,
"Craig A. James" <[EMAIL PROTECTED]> 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).
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
