Search found 45 matches

by piglet
Wed Mar 20, 2013 3:24 pm
Forum: Vertica Performance Tuning
Topic: Should I Disable Auto Commit During Load?
Replies: 1
Views: 5722

Should I Disable Auto Commit During Load?

Hi all,

One way we speed up our MySQL tables loads is to disable AUTOCOMMIT. Is this something recommended that we do in Vertica prior to loading data with the COPY command?

Thanks!!!
by piglet
Fri Jan 18, 2013 5:50 pm
Forum: New to Vertica Database Administration
Topic: What is the Initiator Node?
Replies: 3
Views: 8706

Re: What is the Initiator Node?

Thanks jpcavanaugh !

So basically its what ever node I connect to and then do something, i.e. run a query. Cool. For some reason I was thinking there was a "main" node of sorts. :oops:
by piglet
Fri Jan 18, 2013 2:24 pm
Forum: New to Vertica Database Administration
Topic: What is the Initiator Node?
Replies: 3
Views: 8706

What is the Initiator Node?

Hi guys,

How do I determine which node in a cluster that is considered to be the "initiator node"? And what exactly is the "initiator node" for that matter?

Thank you
by piglet
Sat Dec 22, 2012 11:31 am
Forum: Vertica Tips, Lessons and Examples
Topic: Generate Random Ints with RANDOMINT
Replies: 1
Views: 5868

Re: Generate Random Ints with RANDOMINT

Hmm.

Why did Vertica choose that the value we send into the RANDOMINT function parameter not be included as one of the available return values? I would hope that RANDINT(10) could return a random int between 0 and 10 and not 0 and < 10.
by piglet
Sat Dec 22, 2012 11:22 am
Forum: Request for New Forums Categories
Topic: Holidays forum
Replies: 2
Views: 17593

Re: Holidays forum

YEAH!
by piglet
Sat Dec 22, 2012 11:21 am
Forum: Vertica SQL
Topic: Random Number (Between Negative and Positive)
Replies: 4
Views: 10797

Re: Random Number (Between Negative and Positive)

Thanks, those are perfect examples of what I need!
by piglet
Wed Dec 19, 2012 9:50 pm
Forum: Vertica SQL
Topic: Random Number (Between Negative and Positive)
Replies: 4
Views: 10797

Re: Random Number (Bewteen Negative and Positive)

Hah! That's so simple and perfect! Thanks! I should have thought of that. :roll:

Go to advanced search