Search found 11 matches
- Thu May 08, 2014 5:29 pm
- Forum: Vertica Management Console
- Topic: MC internals
- Replies: 1
- Views: 13825
Re: MC internals
MC gets data from the data_collector process. data_collector is also a table. Select * from data_collector; In that list, you'll see all the tables that store data (the dc_* tables) that MC uses to pull information for its various reports. For example, dc_info_by_minute has IO information aggregated...
- Sun Apr 20, 2014 5:52 am
- Forum: Announcements, Events and Activities
- Topic: HP Vertica Big Data Conference 2014
- Replies: 3
- Views: 8676
Re: HP Vertica Big Data Conference 2014
Pretty much all of Vertica. Bring your questions. Last year the engineers hung out and answered questions. I'm sure they'll do that again.
- Sun Apr 20, 2014 5:52 am
- Forum: Vertica Database Administration
- Topic: How does Vertica evaluate columns for encoding type?
- Replies: 3
- Views: 7864
Re: How does Vertica evaluate columns for encoding type?
I think the answer is: it depends on many things. If DBD is ran under the "storage footprint" option, DBD will compress and encode every column in every possible way in order to achieve maximum storage. Maximum storage is often at odds with performance, however. So, it will probably tend to favor th...
- Sun Apr 20, 2014 5:45 am
- Forum: Vertica Database Administration
- Topic: max k-safety
- Replies: 5
- Views: 10685
Re: max k-safety
I know they exist, but we typically don't recommend K=2 because the ROI just really isn't there. If you really demand 100% uptime, a DR solution is your best alternative, vs. adding that much more data into your existing cluster.
- Sat Apr 12, 2014 6:54 pm
- Forum: Vertica SQL
- Topic: Quarterly Partition non-deterministic error
- Replies: 3
- Views: 8654
Re: Quarterly Partition non-deterministic error
Nice solution. For future reference, a non-deterministic function is a function that returns different things depending on where you happen to be standing on the face of the planet. Date is often one of those. Though, usually we see problems with date+TZ giving problems. It's possible that your LINU...
- Sat Apr 12, 2014 6:49 pm
- Forum: New to Vertica Database Administration
- Topic: What is the full meaning of the event in query_events?
- Replies: 2
- Views: 11960
Re: What is the full meaning of the event in query_events?
As Norbertk mentioned, most of them are benign and informational. Things to avoid: SPILL events, MEMORY LIMIT events. Things to watch out for: HISTOGRAM events - the workload analyzer output will inform you in the Tuning Recommendations window of the Management Console which projections need to have...
- Sat Apr 12, 2014 6:42 pm
- Forum: New to Vertica Database Administration
- Topic: How to segment a projection
- Replies: 4
- Views: 9608
Re: How to segment a projection
Not a super-easy thing to answer, since there's a lot that goes into this, but in general, the above is all accurate. But even segmenting on a very cardinal PK might not be optimum, depending on what you're trying to accomplish. For example, even having perfect distribution of data through a PK segm...