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