On Sat, Nov 7, 2009 at 9:32 PM, Melvin Davidson <[email protected]>wrote:
> >Yep, pg 8.3.7 and slony 1.2.14 at the moment. If I do this on a > >machine with JUST the objects I'm replicating, I can get 10 seconds > >per table and 5 or so per sequence. > > >On the DB with 29000 other objects not replicated, it gets up to 30 > >seconds per table and 20 seconds per sequence. Which means a 5 hour > >time for create set. And if autovac kicks in it blocks create set. > >so I had to turn that off. > > This sound more like O/S and hardware tuning than anything else. > Just out of curiosity, what is the O/S and hardware configuration? > > I would at least hope that the data and WAL files are on separate disks? > By the by, the 12 disk RAID-10 can sustain reads of about 450Meg/second and writes of about 380 to 400Megs/second. However, autovac gets no where near this, ON PURPOSE, to keep it out of the way of the rest of the db during the day.
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
