roctaiwan nettreeinc at gmail.com
Sun Sep 27 20:22:20 PDT 2009
I have about 4G of physical HD spaces just for the 10M records, I believe it
should be plenty, or it isn't.... good point. I will watch out on that. 



melvin6925 wrote:
> 
>>It took about 30 mins to load 1M records. No error messages I observe. 
> 
> If you are doing this in a single transaction
> IE: 
> BEGIN; insert 10m records; COMMIT;
> 
> 
> Then the time it takes to replicate 10M would be about 5 hours.
> 
> IOW, the more records you change, the longer it takes.
> 
> However, have you checked how much physical disk space you have? If you
> don't have enough on the slave, then the transaction will abort and cause
> a rollback, which will take even longer to undo.
> 
> 
> 
> Melvin Davidson 
> 
> 
> 
>       
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
> 
> 

-- 
View this message in context: http://www.nabble.com/copying-large-file-won%27t-get-replicate-tp25609853p25640141.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.



More information about the Slony1-general mailing list