Sun Sep 27 20:22:20 PDT 2009
- Previous message: [Slony1-general] copying large file won't get replicate
- Next message: [Slony1-general] copying large file won't get replicate
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
- Previous message: [Slony1-general] copying large file won't get replicate
- Next message: [Slony1-general] copying large file won't get replicate
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list