resource pools
axnels2
Vertica Customer
if we have resource pools defined but not used or assigned to an existing user, does it use available memory?
0
Best Answers
-
Vertica_Curtis Employee
It would only use memory if you assigned it a MEMORYSIZE. That's reserved memory, and would be used by the resource pool, regardless of whether queries were running in it or not.
5 -
Pan Employee
That depends on how you defined the resource pool, if assigned memorysize only, then it will reduce capacity of total , if assigned maxmemorysize only (memorysize is 0), it does not and will borrow from general pool when needed.
5
Answers
thank you for clarifying that.
on a different topic, we have a constantly running etl processes on some tables that have data from the traffic across entire network. I have analyze scheduled to run every 15 minutes but was told that might be creating more issues. What is a rule of thump for constantly changing data tables.
axnels2, are you asking about how frequently should you be loading the table, or are you concerned about the impacts of querying against a table that you're always loading into? What is the nature of the issue here?
I am asking about how often should I be collecting statistics on a given table because its changing constantly.