The Watcom Rule would imply "Intra-query parallelism is not used for connections with priority set to Background"... is that true? The Help for the old background_priority option [deprecated] says "Intra-query parallelism is not used for connections with background_priority set to On". However, the Help for the new priority option makes no such claim for SET TEMPORARY OPTION priority = 'Background'. |
I have justed noted that the docs do tell about that, I have not checked reality:) From the v17 "Parallelism in queries" topic:
Makes sense, particularly as the deprecated Background_priority option is implemented as setting the priority option to 'Background'... |