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/
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
