Using Batch Inserts

Using batch inserts will improve replication performance for transactions that perform multiple inserts into a single table. Spock will switch to batch mode when a transaction does more than five INSERTs.

You can only use batch mode if there are no INSTEAD OF INSERT and BEFORE INSERT triggers on the table and when there are no defaults with volatile expressions for columns of the table. Also the batch mode will only work when spock.conflict_resolution is set to error. The default value of spock.conflict_resolution is true.