Set values for several of the parallel DSI configuration parameters if your transactions frequently conflict with each other.
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 dsi_sqt_max_cache_size to 1 million bytes on 32-bit platforms and 20 million bytes on 64-bit platforms.