On Thu, Jan 2, 2014 at 12:35 PM, Tory M Blue <[email protected]> wrote: > > Wondering what settings I need to speed this up. To do a rebuild of a db it > takes a long time, 6 hours for a singe table. No I/O issues, no load, just > slon postgres taking their sweet old time. I would like to use the resources > available to speed this up.
1: How fast can you scp a file between these two boxes? 2: How far apart are they / is there a lot of latency between them? 3: How fast can you create a good sized file on the slave? (dd if=/etc/zero of=bigfile bs=1000000 count=1000) If they are far apart then make sure your slon daemon is running on the slave not the master. This can make a huge difference. > #sync_max_rowsize=8192 Try turning this up to 32768 as well. -- To understand recursion, one must first understand recursion. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
