If the effect of intra-query parallelism is marginal, lowering the multiprogramming level can be done safely without reducing overall system throughput.
The -gn option controls the server's multiprogramming level.
gn オプションは、サーバのマルチプログラミング・レベルを制御します。
Setting the database server's multiprogramming level
データベース・サーバのマルチプログラミング・レベルの設定
It is recommended that you experiment with your application's workload to analyze the effects of the server's multiprogramming level on server throughput and request response time.
Hence, setting a higher multiprogramming level increases the server's memory footprint, and reduces the amount of memory available for the cache because the amount of available address space is reduced.
However, lowering the multiprogramming level may improve the response time of individual requests because there are fewer requests to compete for resources, and there is a lower probability of lock contention.
Examples are used only to help you translate the word or expression searched in various contexts. They are not selected or validated by us and can contain inappropriate terms or ideas. Please report examples to be edited or not to be displayed. Potentially sensitive, inappropriate or colloquial translations are usually marked in red or in orange.