Search found 1742 matches

by JimKnicely
Thu Jul 27, 2017 10:13 pm
Forum: Vertica Database Administration
Topic: change ip address
Replies: 6
Views: 763

Re: change ip address

I think you will have to re-import the DB using the new IPs
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: 25

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: 25

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: 138

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

Go to advanced search