>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 



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090927/1bbb73be/attachment.htm