If your transactions conflict with each other frequently, set the parallel DSI configuration parameters as follows:
dsi_serialization_method – set this parameter to wait_for_commit.
dsi_num_large_xact_threads – set this parameter to 2. If you are configuring parallel DSI in a warm standby application, set the dsi_num_larg_xact_threads parameter for the standby database to one more than the number of simultaneous large transactions executed at the active database.
dsi_num_threads – set this parameter to 3 plus the value of the dsi_num_large_xact_threads parameter. If your transactions are usually small, such as one or two statements, set dsi_num_threads to 1 plus the value of dsi_num_large_xact_threads.
Setting the parallel_dsi configuration parameter on provides a shorthand method for configuring parallel DSI as described above. It also sets the dsi_sqt_max_cache_size parameter to 1 million bytes.
