<div><div>Slony operates row based. It has no idea how many client side statements have created those rows. Or if any row was inserted, updated or deleted as a direct result of a client query, a stored procedure, a trigger or a cascaded foreign key operation.</div><div><br/></div><div><br/></div><div>Jan</div><div><br/></div><div><i><font style="color:#333333">--</font></i></div><div><i><font style="color:#333333">Anyone who trades liberty for security deserves neither </font></i></div><div><i><font style="color:#333333">liberty nor security. -- Benjamin Franklin</font></i></div></div><br><br>Raghav <ragavendra.dba@gmail.com> wrote:<br><br>Hi,<div><br></div><div>insert into stest values(generate_series(1,100));</div><div>or</div><div><div>insert into stest values (101),(102),(103);</div><div><br></div></div><div>How does above two SQL statements treated and counted in sl_apply_stats.as_num_insert column ?</div>
<div><br></div><div>I feel it should be considered as one INSERT statement, no ?, </div><div>But it has multiplied the count even with generate_series.</div><div><br></div><div>Test case:</div><div><br></div><div>postgres=# select as_num_insert from _rep220.sl_apply_stats ; //before insert</div>
<div> as_num_insert</div><div>---------------</div><div> 0</div><div>(1 row) </div><div><br></div><div><div>postgres=# insert into stest values (generate_series(1,100));</div><div>INSERT 0 100</div></div><div><br>
</div><div><div>postgres=# select as_num_insert from _rep220.sl_apply_stats ;</div><div> as_num_insert</div><div>---------------</div><div> 100</div><div>(1 row)</div></div><div><br></div><div><div>postgres=# insert into stest values (101),(102),(103);</div>
<div>INSERT 0 3</div></div><div><br></div><div><div>postgres=# select as_num_insert from _rep220.sl_apply_stats ;</div><div> as_num_insert</div><div>---------------</div><div> 103</div><div>(1 row)</div></div><div>
<br></div><div><br></div><div>-- <br><div>Regards</div><div>Raghav</div><div>Blog: htt://<a href="http://raghavt.blogspot.com/" target="_blank">raghavt.blogspot.com/</a></div>
</div>