Search found 11 matches

by cbennett
Thu May 08, 2014 5:29 pm
Forum: Vertica Management Console
Topic: MC internals
Replies: 1
Views: 3849

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...
by cbennett
Sun Apr 20, 2014 5:52 am
Forum: Announcements, Events and Activities
Topic: HP Vertica Big Data Conference 2014
Replies: 3
Views: 2894

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.
by cbennett
Sun Apr 20, 2014 5:52 am
Forum: Vertica Database Administration
Topic: How does Vertica evaluate columns for encoding type?
Replies: 3
Views: 2223

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...
by cbennett
Sun Apr 20, 2014 5:45 am
Forum: Vertica Database Administration
Topic: max k-safety
Replies: 5
Views: 2723

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.
by cbennett
Sat Apr 12, 2014 6:54 pm
Forum: Vertica SQL
Topic: Quarterly Partition non-deterministic error
Replies: 3
Views: 2840

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...
by cbennett
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: 4210

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...
by cbennett
Sat Apr 12, 2014 6:42 pm
Forum: New to Vertica Database Administration
Topic: How to segment a projection
Replies: 4
Views: 2545

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...

Go to advanced search