Vertica's Resource pools - whats in SAP IQ?

[Former Member]

HP Vertica have resource pools for manage workloads.

And User Profiles

• Resource pool to which a user is assigned (RESOURCE POOL)
• Maximum amount of memory a user's session can use (MEMORYCAP)
• Maximum amount of temporary file storage a user's session can use (TEMPSPACECAP)
• Maximum amount of time a user's query can run (RUNTIMECAP)

https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/AdministratorsGuide/ManageWorkloads/Resou...

Is there something similar in IQ?

[tayeb_hadjou]

Hi Mikhail,

In IQ, certain resource limitations are controlled via options like Max_Query_Time, Max_IQ_Threads_Per_Connection, Max_Temp_Space_Per_Connection, Iqgovern_Priority.

They can be set for a single user or a Group of users.

Regards,

Tayeb