| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | "Craig A(dot) James" <cjames(at)modgraph-usa(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: No vacuum for insert-only database? |
| Date: | 2006-03-13 18:52:08 |
| Message-ID: | 20060313185208.GA5558@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, Mar 13, 2006 at 09:19:32 -0800,
"Craig A. James" <cjames(at)modgraph-usa(dot)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).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2006-03-13 19:15:00 | Re: firebird X postgresql 8.1.2 windows, performance comparison |
| Previous Message | andremachado | 2006-03-13 18:11:54 | firebird X postgresql 8.1.2 windows, performance comparison |