resource pool

weixshen

Hi, I have a cluster with three nodes, the set of resource pool is default. When I test the performance, I meet a problem:
 
Some of the queries fail to finished, for example: "create table... as select * ..." is not executed, and the error hints resource pool general is insufficient... However, the usage of whole system's RAM is less than 50%, while the maxmemorysize of general resource pool is 95%. WHY? 

Navin_C

Hi weixshen,

What is size of your select buffer data.
How much is the RAM of your system. Is Vertica the only active major process on the system.

Try seeing the resource_acquisitions table to understand the usage of RAM while your query is running.
This will lead you to get the RAM usage at the time of execution by Vertica and not the whole system

Hope this helps.