>Yep, pg 8.3.7 and slony 1.2.14 at the moment.=A0 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.=A0 Which means a 5 hour
>time for create set.=A0 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
 =






      =

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20091107/=
8a61f38a/attachment.htm