Limits impact on the performance of connections other than the current connection.
|PUBLIC role||For current user||For other users|
|Allowed to set permanently?||Yes, with SET ANY PUBLIC OPTION||Yes||Yes, with SET ANY PUBLIC OPTION|
|Allowed to set temporarily?||Yes, with SET ANY PUBLIC OPTION||Yes (current connection only)||No|
When this option is set to On, requests execute at the Background priority level. When this option is set to Off, requests execute at the value specified by the Priority option.
Intra-query parallelism is not used for connections with background_priority set to On.