<div dir="ltr"><br><div class="gmail_extra">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.</div>
<div class="gmail_extra"><br></div><div class="gmail_extra">The table is</div><div class="gmail_extra"><br></div><div class="gmail_extra"><div class="gmail_extra">2013-12-21 19:17:58 PST CONFIG remoteWorkerThread_1: Begin COPY of table "impressions"</div>
<div class="gmail_extra">2013-12-21 19:37:03 PST CONFIG remoteWorkerThread_1: 12657163552 bytes copied for table ”impressions” </div><div class="gmail_extra">2013-12-22 01:40:22 PST CONFIG remoteWorkerThread_1: 22944.144 seconds to copy table ”impressions” <— 6 hours</div>
<div class="gmail_extra"><br></div><div class="gmail_extra">Postgres 9.2.4 slony 2.1.3</div><div class="gmail_extra"><br></div><div class="gmail_extra">This is a larger table, but because of bloat etc, we need to do ground ups to clean it out every so often (Vacuums don't do it).</div>
<div class="gmail_extra"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra">Slony config , pretty much at default other than sync interval.</div><div class="gmail_extra"><br></div><div class="gmail_extra">
<div class="gmail_extra"># Check for updates at least this often in milliseconds.</div><div class="gmail_extra"># Range: [10-60000], default 2000</div><div class="gmail_extra">sync_interval=1000</div><div class="gmail_extra">
#sync_interval_timeout=10000<br></div><div class="gmail_extra"><div class="gmail_extra"># apply every single SYNC by itself.</div><div class="gmail_extra"># Range: [0,100], default: 6</div><div class="gmail_extra">#sync_group_maxsize=6</div>
<div class="gmail_extra">#sync_max_rowsize=8192</div><div class="gmail_extra">#sync_max_largemem=5242880</div><div class="gmail_extra"><br></div><div class="gmail_extra">I either need some advanced settings for when we are doing a rebuild, to speed up the process, or I need to do some configurations that stay during normal workloads as well. But normal workloads things are replicated and keep in sync, it's just the rebuild portion. I would like to see it actually stressing my boxen :)</div>
<div class="gmail_extra"><br></div><div class="gmail_extra">Thanks</div><div class="gmail_extra">Tory</div></div></div></div></div>