On Sat, Nov 7, 2009 at 9:32 PM, Melvin Davidson <melvin6925 at yahoo.com>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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20091107/=
27f18969/attachment.htm