On Fri, 2004-12-31 at 10:15 -0600, Jeremiah Jahn wrote:
> Slony seems to be running a little slow, and I was wondering if there is
> a way to speed things up that I missed in the documentation.
> 
> It is taking more than 48 hours to replicate one 58 gig db to another
> machine over a gigabit network. The client and server have raided 15K

Not all that surprising. It took us nearly a week to replicate and catch
up to a 160GB database.

> scsi 360 drives. This initial dump is taking more time than a dump and
> restore. I thought this would move a little faster. Did I miss something
> in the documentation? Is there some setting that would vastly speed
> things up? I'm using sl-1.0.5 and pg-7.4.5. 

One big item would be to create indexes (other than primary keys) after
Slony has completed the initial copy. Slony only really needs primary
keys to do it's work, so it won't miss the others.
--