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. _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
