Search found 13 matches
- Tue Nov 04, 2014 9:06 pm
- Forum: Vertica Database Administration
- Topic: maxconcurrency doesn't seem to work in Resource Pooling
- Replies: 6
- Views: 12590
Re: maxconcurrency doesn't seem to work in Resource Pooling
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...
- Tue Nov 04, 2014 6:40 pm
- Forum: Vertica Database Administration
- Topic: maxconcurrency doesn't seem to work in Resource Pooling
- Replies: 6
- Views: 12590
Re: maxconcurrency doesn't seem to work in Resource Pooling
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...
- Tue Nov 04, 2014 5:41 pm
- Forum: Vertica Database Administration
- Topic: maxconcurrency doesn't seem to work in Resource Pooling
- Replies: 6
- Views: 12590
Re: maxconcurrency doesn't seem to work in Resource Pooling
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 --------...
- Tue Nov 04, 2014 3:58 pm
- Forum: Vertica Database Administration
- Topic: maxconcurrency doesn't seem to work in Resource Pooling
- Replies: 6
- Views: 12590
maxconcurrency doesn't seem to work in Resource Pooling
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...
- Tue Sep 30, 2014 3:52 pm
- Forum: Vertica Database Administration
- Topic: Vertica partions and partitioning questions
- Replies: 5
- Views: 12406
Re: Vertica partions and partitioning questions
@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...
- Mon Sep 29, 2014 8:15 pm
- Forum: Vertica Database Administration
- Topic: Vertica partions and partitioning questions
- Replies: 5
- Views: 12406
Vertica partions and partitioning questions
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...
- Wed Aug 28, 2013 2:25 pm
- Forum: JDBC
- Topic: Column must appear in the GROUP BY
- Replies: 11
- Views: 43548
Re: Column must appear in the GROUP BY
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? ...