Hi,

insert into stest values(generate_series(1,100));
or
insert into stest values (101),(102),(103);

How does above two SQL statements treated and counted in
sl_apply_stats.as_num_insert column ?

I feel it should be considered as one INSERT statement, no ?,
But it has multiplied the count even with generate_series.

Test case:

postgres=# select as_num_insert from _rep220.sl_apply_stats ;     //before
insert
 as_num_insert
---------------
           0
(1 row)

postgres=# insert into stest values (generate_series(1,100));
INSERT 0 100

postgres=# select as_num_insert from _rep220.sl_apply_stats ;
 as_num_insert
---------------
           100
(1 row)

postgres=# insert into stest values (101),(102),(103);
INSERT 0 3

postgres=# select as_num_insert from _rep220.sl_apply_stats ;
 as_num_insert
---------------
           103
(1 row)


-- 
Regards
Raghav
Blog: htt://raghavt.blogspot.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20130709/9c5b7907/attachment.htm