Hi Jim, Thank you for the answer, and the system tables tip. So I tweaked your query a little bit to see if there are any other pools used, and the result is no, only lp_pool is used: nba=> select ra.pool_name, count(*) nba-> from v_monitor.query_profiles qp nba-> join v_monitor.resource_acquisition...

Actually, I take that back, as it seems to be a queue for 2 statements only. Also running this: nba=> select count(*) from v_monitor.query_profiles where user_name = 'lp_user' and is_executing; count ------- 238 (1 row) shows that there are 238 queries being executed, so I guess I am still back at s...

Hi knicely87, Thank you for the tip, resource_queues returned what I was looking for: nba=> select * from v_monitor.resource_queues where pool_name = 'lp_pool'; node_name | transaction_id | statement_id | pool_name | memory_requested_kb | priority | position_in_queue | queue_entry_timestamp --------...

Hi all, So I created a low priority user that is assigned to a resource pool with maxconcurrency set to 8, but I was surprised to seeing a lot more than that running at a given time. Here's more information to help everyone understand what I am running through and help me understand why there aren't...

@norbertk Thank you for your input. And I even think reaching 1024 year+month will take a while, and by then, the "old" data can be moved out of the partitions to a separate tables. @scutter Thanks for the advice, and will definitely not use the MERGE_PARTITIONS() knowing it has been deprecated (and...

I've been using Vertica 6.1.3 in a 3 nodes cluster for a while and time has come to partition the data to get the most out of it. Reading through the documentation and the nature of the data that I am dealing with, it looks like it's best to partition data by year-month for the last 12 months, and h...

Right, When I said 'not handled properly' I was talking about the vertica driver. And this makes me think that this is the reason for my original problem, since all queries from the app are prepared statements. Any idea on the ETA for this feature in the driver side? if not, where/who should I ask? ...