resource pools

axnels2

if we have resource pools defined but not used or assigned to an existing user, does it use available memory?

Vertica_Curtis

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.

Pan

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.

axnels2

thank you for clarifying that.

axnels2

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.

Vertica_Curtis

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?

axnels2

I am asking about how often should I be collecting statistics on a given table because its changing constantly.