On 12-06-08 02:50 PM, dinesh kumar wrote: > Thank you so much Steve ... > > We are using Slony 2.1.x ... We are still at the initial stage only... > Slony is still trying to copy the data from source to destination host .. > > >> Has your initial copy_set finished? > > Here only, we are facing problem... Slony struggling to copy the data .. > It went well upto 140 GB. From 141GB onwards the build started slow.. > Now it's very very very slow ... > > Let me know if you need any configurations what we have used ... >
Are you doing this copy over a WAN? How long is this taking? How long does it normally take you to load a pg_dump of your 3TB database on this hardware? Can you tell what the bottleneck is? Are you IO bound on the slave? Are you CPU bound on the slave? There isn't a lot of slony configuration that controls the intial sync which is done by COPY. There are a bunch of parameters that control the behaviour to process normal SYNC events after your initial subscription but I don't think those would effect the intial copy. > Thanks again for your response .. > > Best Regards, > Dinesh > > > > On Sat, Jun 9, 2012 at 12:12 AM, Steve Singer <[email protected] > <mailto:[email protected]>> wrote: > > On 12-06-08 02:26 PM, dinesh kumar wrote: > > Hi All, > > Can i get any slony recommendations for the replication of 3 TB Data > with slony. I mean, slon configuration parameters .. > > As of now, it's copied 145 GB of data from Primary to slave and > seems > from here onwards it's running very very very slow .. No Errors in > slony logs and pg_logs ... Slon process is running with it's default > configuration parameters ... > > > You don't tell us what version of slony your running. I would > recommend you run at least 2.1.x. > > 1.2.x and 2.0.x have a performance bug that might mean that slony > can fall so far behind on the initial sync that it might never catch up. > > > > > Your help is highly appreciated .. > > Thank You, > Dinesh > > > > _________________________________________________ > Slony1-general mailing list > [email protected].__info > <mailto:[email protected]> > http://lists.slony.info/__mailman/listinfo/slony1-__general > <http://lists.slony.info/mailman/listinfo/slony1-general> > > > _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
