The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Question about CPUAFFINITYMODE and CPUAFFINITYSET

Hi,
Suppose I have two different resource pools with CPUAFFINITYSET=80% in shared mode.
What will happen to the second resource pool if the first one reaches to 80% CPU usage? will the second pool's queries be queued or will the server reach 100% CPU?
Thank you !
0
Answers
That percentage is used to define which CPU will be used by the Resource Pool. For example, Vertica database is running on the server that has 4 CPUs and it creates 2 Resource Pools with CPUAFFINITYSET parameter as below:
We can see the information of the assigned CPUs used by each Resource Pool in resource_pool_status:
In this case, both Resource Pool use CPU 0, 1, 2.
You can see another example in the product documentation as below:
https://www.vertica.com/docs/12.0.x/HTML/Content/Authoring/SQLReferenceManual/SystemTables/MONITOR/RESOURCE_POOL_STATUS.htm#Examples