On Mar 21, 2006, at 10:05 PM, Rod Taylor wrote:

> 400GB at 2B transactions/year already requires nearly double hardware
> (CPU & RAM) to get through the initial data copy as would otherwise be
> required for standard DB operation. Lack of VACUUM during this time  
> is a
> killer. Emptying sl_log_1 with everything being in a single  
> transaction
> at the beginning is also painful.

For something this big, I'd want to do one table in a set at a time,  
and merge the sets as it completes each table.