Interesting Jim. I do not see these tables in my version of the database ( v7.0.1-0). What is your db version? Or is it that we need to explicitly enable some of these tables, as I understand these virtual table details are not mentioned anywhere in the documentation and apparently vertica keeps cha...

Thank you nnani. However, I am looking for historical resource pool usage information by minute, hour etc (not sure if there is such a table or not) so that we can tune the memory allocation to each resource pool. Do you know any such system tables?

My db version is v7.0.1-0

Fred

Hello, I was exploring the options get the resource usage statistics at the resource pool level and thats when I ended up with a set of these data collector tables, which I thought would collect the statistics by time slice as per its naming suffix. However, to my suprise, I could not find any of th...

Thanks Sharon and Norbert for your inputs.

Fred

Hello everyone, I would like to understand what action does the resource manager take for allocating the resource for the following scenario. Lets say following are the parameters for a resource pool: MEMEORYSIZE=MAXMEMORYSIZE=4G Planned concurrency =4 Max concurrency=4 Lets say 4 queries are submit...

Thanks Norbert. That makes sense. Also, AHM need not advance at the time of commit itself as I understand AHM advance depends on the Epoch management parameters.