| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, "Craig A(dot) James" <cjames(at)modgraph-usa(dot)com> |
| Subject: | Re: No vacuum for insert-only database? |
| Date: | 2006-03-13 19:16:53 |
| Message-ID: | 200603131116.53998.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Craig,
> Transaction ID wraparound will be a problem at a bit less than 2 billion
> transactions. So if you vacuum the table every 1 billion transactions
> you are safe. I suggest you read the "routine maintenance" section in
> the docs; the wraparound issue is explained there.
For reference, we calculated on a data warehouse with about 700 million
rows in the main fact table that we had 6 years until XID wraparound.
Mind you, that's partly because all of our rows were inserted in large
batches of 100,000 rows each.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2006-03-13 20:02:26 | Re: firebird X postgresql 8.1.2 windows, performance |
| Previous Message | Josh Berkus | 2006-03-13 19:15:00 | Re: firebird X postgresql 8.1.2 windows, performance comparison |