Search found 36 matches

by doug_harmon
Wed Mar 25, 2015 5:43 pm
Forum: Vertica Database Administration
Topic: Vertica Database Baseline
Replies: 9
Views: 2352

Re: Vertica Database Baseline

I've created a SQL Script to capture what is in the v_monitor.query_requests table, which keeps a rolling history of queries and their run times. Since this table keeps a rolling history, it needs to be backed up to another history table for long term storage on a regular basis. This allows us to id...
by doug_harmon
Thu Jan 22, 2015 9:58 pm
Forum: New to Vertica
Topic: Concurrency in Vertica
Replies: 7
Views: 3026

Re: Concurrency in Vertica

Rolling your own will be more development work, but one advantage is that you cut down on the overhead that you get with JDBC. By any chance do you have access to the linux boxes that Vertica is installed on? There is a vertica vsql client in /opt/vertica/bin/vsql that can run SQL queries from the c...
by doug_harmon
Thu Jan 22, 2015 5:38 am
Forum: New to Vertica
Topic: Concurrency in Vertica
Replies: 7
Views: 3026

Re: Concurrency in Vertica

You're welcome. I'm curious, what was the result of your Vertica PoC?
by doug_harmon
Tue Jan 20, 2015 4:56 am
Forum: New to Vertica
Topic: Concurrency in Vertica
Replies: 7
Views: 3026

Re: Concurrency in Vertica

Use Apache Jmeter with the Vertica JDBC driver for performance testing.
http://jmeter.apache.org/usermanual/bui ... -plan.html
The example given is mysql, but it's relatively easy to convert it to Vertica.
by doug_harmon
Sat Jan 17, 2015 12:49 am
Forum: New to Vertica
Topic: Concurrency in Vertica
Replies: 7
Views: 3026

Re: Concurrency in Vertica

Talk to the people setting up your cluster. Vertica has a cookbook that describes how to configure a DL-380 box for a Vertica cluster. http://www.vertica.com/resources-for-planning-for-and-configuring-hardware/ Share it with them and check after they're done to ensure that they followed the cookbook...
by doug_harmon
Thu Dec 18, 2014 3:58 pm
Forum: Vertica Links
Topic: Graph Analytics using the Vertica Relational Database
Replies: 0
Views: 1214

Graph Analytics using the Vertica Relational Database

Source: http://arxiv-web3.library.cornell.edu/abs/1412.5263 Graph Analytics using the Vertica Relational Database Alekh Jindal, Samuel Madden, Malu Castellanos, Meichun Hsu (Submitted on 17 Dec 2014) Abstract Graph analytics is becoming increasingly popular, with a deluge of new systems for graph an...

Go to advanced search