>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?
Melvin Davidson
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
