Skip to main content

Posts

Showing posts from February, 2019

Vertica Request for X percent of Y CPUs rounds to zero CPUs

when trying to create a resource pool using some % of the total CPUs you may encounter this error: Vertica Request for 10% percent of 4 CPUs rounds to zero CPUs \n (6006) (SQLExecDirectW) why? since 10% of 4, rounded by vertica to 0. and you can allocate 0 CPUs to a resource pool how to fix: fix % to be at least 25% or use static allocation of CPU set to a resource pool