Vivek Gupta wrote: > We have upgrade the Slony from 1.1.5 to 2.0.4rc2 and additionally the > platform has been migrated from 32-bit to 64-bit. We have been observing > performance degradation in terms of the replication time. With the set > data earlier it was taking ~10 min to replicate now it’s taking ~2 hours > for the same data set. Has anyone faced performance issues with 2.0.4rc2?
Hmm, any ideas why it is taking ~2 hours? What is load like on your machines? You mentioned higher memory usage for slon in your other post. Is this causing your machine to swap? Have you also changed postgresql versions? (I don't think you mentioned which version of pg your running) Are you using auto vacuum? Do you have a lot of table bloat? How many rows on average are in sl_log_1 and sl_log_2? Does this number keep growing? > > > > With regards, > > Vivek Gupta > > > ------------------------------------------------------------------------ > > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general -- Steve Singer Afilias Canada Data Services Developer 416-673-1142 _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
