Search found 1741 matches

by JimKnicely
Thu Jul 27, 2017 2:44 pm
Forum: Vertica Data Load
Topic: Loading data via COPY to a table without ksafty.
Replies: 3
Views: 24

Re: Loading data via COPY to a table without ksafty.

Vertica can load data extremely fast! Instead of doing a single COPY command, make sure you do things in parallel: https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/AdministratorsGuide/BulkLoadCOPY/UsingParallelLoadStreams.htm https://my.vertica.com/kb/Data-Loading-in-Vertica-Using-COPY/Con...
by JimKnicely
Thu Jul 27, 2017 1:32 pm
Forum: Vertica Database Administration
Topic: Reverse search
Replies: 1
Views: 8

Re: Reverse search

Are you talking about in vsql? vsql supports the tecla library for convenient line editing and retrieval. See: https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/ConnectingToVertica/vsql/CommandLineEditing.htm http://www.astro.caltech.edu/~mcs/tecla/tecla.html Sounds like you are looking for...
by JimKnicely
Tue Jul 25, 2017 8:44 pm
Forum: Vertica Data Load
Topic: Loading data via COPY to a table without ksafty.
Replies: 3
Views: 24

Re: Loading data via COPY to a table without ksafty.

Hi, As far as I know, you cannot create a permanent table that has a KSAFE value less than the system KSAFE value ... dbadmin=> select current_fault_tolerance from system; current_fault_tolerance ------------------------- 1 (1 row) dbadmin=> create table jim (c1 int) ksafe 0; ERROR 4478: Projection ...
by JimKnicely
Thu Jun 29, 2017 2:56 pm
Forum: Vertica Database Administration
Topic: update statistics
Replies: 1
Views: 103

Re: update statistics

Hi, Vertica does not compute a table's complete set of statistics automatically, as that would negatively affect the database performance. However Vertica does regularly collect some statistics incrementally, like table row counts every 60 seconds (see AnalyzeRowCountInterval parameter). dbadmin=> s...
by JimKnicely
Thu Jun 15, 2017 2:21 pm
Forum: Vertica Links
Topic: The Vertica Technical Team's new LinkedIn account!
Replies: 0
Views: 137

The Vertica Technical Team's new LinkedIn account!

The Vertica Technical Team is pleased to announce we have a new LinkedIn account! Please connect with us for the latest posts and updates from the Vertica Community, including the blog and knowledge base. Your feedback helps us create more content that can better serve your needs. If you have ideas ...
by JimKnicely
Thu Jun 15, 2017 2:19 pm
Forum: Vertica Links
Topic: Understanding Users, Privileges, and Roles
Replies: 0
Views: 94

Understanding Users, Privileges, and Roles

Another great Vertica Blog post "Understanding Users, Privileges, and Roles" by Soniya! Every Vertica database has one or more users. When users connect to the database, they log in with credentials that a superuser defines. Database users should only have access to the database resources they need ...

Go to advanced search