<div dir="ltr">Postgres 9.2.4, slony 2.1.2 (ya will be pushing to 2.1.3), but with my postgres upgrade had to keep slony version the same for the first go through.<div><br></div><div style>But for 87,873,597 rows it took 3 hours to replicate over a gig link. There were no signs of system health issues, iostat showed hardly anything, no CPU/memory issues, so I'm wondering if there is some tuning that needs to happen?</div>
<div style><br></div><div style>These are my master/slave so do have fsync on, maybe during a rebuild a fsync off is in order, but not sure if that will truly help.</div><div style><br></div><div style>slon config is pretty basic</div>
<div style><br></div><div style>everything is default except for these values:</div><div style><br></div><div style><div>log_level=2</div><div>sync_interval=1000<br></div><div>remote_listen_timeout=10000</div><div><br></div>
<div style>spotlightimpressions has 87,873,597 rows, took 12845.025 seconds</div>
<div style>adimpressions has 1,542,169 rows, took 2098.679 seconds</div><div style>listings has 4,080,091 rows . took 1491.740 seconds</div>
<div><br></div><div>
<p class="">2013-04-24 23:10:19 PDT CONFIG remoteWorkerThread_1: copy table "db"."listings"</p>
<p class="">2013-04-24 23:10:19 PDT CONFIG remoteWorkerThread_1: Begin COPY of table "db"."listings"</p>
<p class="">2013-04-24 23:35:10 PDT CONFIG remoteWorkerThread_1: 1491.740 seconds to copy table "db"."listings"</p>
<p class="">2013-04-24 23:35:23 PDT CONFIG remoteWorkerThread_1: copy table "db"."spotlightimpressions"</p>
<p class="">2013-04-24 23:35:23 PDT CONFIG remoteWorkerThread_1: Begin COPY of table "db"."spotlightimpressions"</p>
<p class="">2013-04-25 03:09:28 PDT CONFIG remoteWorkerThread_1: 12845.025 seconds to copy table "db"."spotlightimpressions" </p>
<p class="">2013-04-25 03:09:28 PDT CONFIG remoteWorkerThread_1: copy table "db"."adimpressions"</p>
<p class="">2013-04-25 03:09:28 PDT CONFIG remoteWorkerThread_1: Begin COPY of table "db"."adimpressions"</p>
<p class="">2013-04-25 03:44:26 PDT CONFIG remoteWorkerThread_1: 2098.679 seconds to copy table "db"."adimpressions" </p></div><div><br></div><div style>Where do I start looking? These tables will only grow and since upgrades require full rebuilds etc, This is already painful, but will only get worse.</div>
<div style><br></div><div style>Thanks</div><div style>Tory</div></div>
</div>