<div dir="ltr"><br><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Jan 3, 2014 at 11:33 AM, Jan Wieck <span dir="ltr"><<a href="mailto:JanWieck@yahoo.com" target="_blank">JanWieck@yahoo.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 01/02/14 16:12, Tory M Blue wrote:<br>
> We are getting outside of slon and into postgres and i'll try to keep<br>
> this light, here are my postgresql custom config aspects<br>
<br>
Postgres and its architecture very much affect the behavior and<br>
performance of Slony. I'm afraid that they cannot be viewed completely<br>
isolate from each other.<br>
<br>
> The hardware is being refreshed but right now it's an 8 core, 32GB<br>
> CentOS system, being replaced with some pretty big hardware<br>
> 256GB/32cores many SSD's. But tuning this now and knowing where I need<br>
> to tweak when I add the added capacity would be great.<br>
<br>
The slon process uses one single database connection to the data<br>
provider for the copy operation and another single database connection<br>
to feed the data into the new replica. A single Postgres session only<br>
utilizes one single core. It therefore makes zero difference if you are<br>
upgrading from a dual core to 64 cores or more.<br>
<br>
The suggestions made about work mem and maintenance work mem are valid.<br>
If you are using a dedicated DB user for all your slon database<br>
connections you can tweak these per server via ALTER USER.<br>
<br>
<br>
Regards,<br>
Jan</blockquote><div><br></div><div><br></div><div>Okay that is interesting.. "If you are using a dedicated DB user for all your slon database connections, you can tweak these per server via Alter User", what will that do for me? We do use the same user across the board and i figured I would just modify my postgresql.conf. So i'm a tad confused :)</div>
<div><br></div><div>And since it appears that my index creation is the big time hole, I'm going to be testing work mem, by going from 100M to 2GB+ and i'll reduce my vacuum processes from 7 to maybe 2 or 3, so I don't blow anything out . But you have intrigued me :)</div>
<div><br></div><div>Thanks</div><div>Tory</div></div></div></div>