<div dir="ltr"><div><br></div>Master : Ubuntu 10.04 LTS, Postgre 9.1.13, Slony 2.0.7 from Ubuntu Package<div>Slave : Ubuntu 10.04 LTS, Postgres 9.1.13, Slony 2.0.7 seems build from source.</div><div>DB size 1.5 TB, Master utilize relative high number of temp tables and relative High number of locks on busy time</div>
<div><br></div><div>DB=# select mode, count(*) from pg_locks group by mode;</div><div> mode | count</div><div>--------------------------+--------</div><div> ExclusiveLock | 112</div><div>
RowShareLock | 37</div><div> AccessExclusiveLock | 208577</div><div> RowExclusiveLock | 33087</div><div> ShareUpdateExclusiveLock | 5</div><div> ShareLock | 54906</div><div>
AccessShareLock | 93607</div><div>(7 rows)</div><div> </div><div>but the slave is relative low on load.</div><div><br></div><div>this is the connection from slave that open from May 25th</div><div>postgres 14090 0.1 1.1 4512644 230760 ? Ss May25 59:08 postgres: slony_user dbname master_ip_address(58554) idle<br>
</div><div class="gmail_extra"><br></div><div class="gmail_extra">On slave, this connection seems always keep on idle status, but on master, this connection often in "<IDLE> in transaction" status for some minutes and hold lock on sl_log_2 while transaction are filling up sl_log_1.</div>
<div class="gmail_extra"><br></div><div class="gmail_extra">Such condition usually happen on server high load time, but on low load it sometimes happen, but not many and does not affect on replication lag.<br><br><div class="gmail_quote">
On Wed, Jul 2, 2014 at 12:37 AM, Steve Singer <span dir="ltr"><<a href="mailto:ssinger@ca.afilias.info" target="_blank">ssinger@ca.afilias.info</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="">On 06/30/2014 01:05 PM, Soni M wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
it seems a slony process that has <IDLE> in transaction for many times.<br>
the client address and the user are identical to slony slave.<br>
<br>
<br>
</blockquote>
<br></div>
Which version of slony are you on?<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class=""> <br></div></blockquote></blockquote></div><br><br clear="all"><div>
<br></div>-- <br><div dir="ltr"><div>Regards,</div><div><br></div>Soni Maula Harriz</div>
</div></div>