Search found 18 matches

by sreediff
Tue Jul 25, 2017 10:15 pm
Forum: Vertica Database Administration
Topic: change ip address
Replies: 7
Views: 976

Re: change ip address

i used catalog editor to change ip and now DB works. Now MC doesnt work. Not sure where to change ip for MC.
by sreediff
Tue Jun 20, 2017 9:09 pm
Forum: Vertica Database Administration
Topic: update statistics
Replies: 1
Views: 194

update statistics

As per https://my.vertica.com/docs/7.2.x/HTML/Content/Authoring/AdministratorsGuide/Statistics/BestPracticesForStatisticsCollection.htm After loading a table with significant volume >50 % the recommendation is to run analyze_statistics which takes 10 pct sample. Is this enough or should we run analy...
by sreediff
Tue Jun 20, 2017 9:04 pm
Forum: Vertica Database Administration
Topic: change ip address
Replies: 7
Views: 976

Re: change ip address

will try on a local vm copy first.
by sreediff
Fri Nov 18, 2016 1:39 pm
Forum: General
Topic: vertica 7.2.3 community edition
Replies: 1
Views: 820

vertica 7.2.3 community edition

where to download 7.2.3 version for red hat 7.
by sreediff
Fri Nov 18, 2016 1:38 pm
Forum: General
Topic: Vertica community edition download
Replies: 1
Views: 2144

Vertica community edition download

where to download vertica 7.2.3 community edition ? I can see community edition for vertica 8.0 only
by sreediff
Wed Oct 19, 2016 8:20 am
Forum: Vertica Database Development
Topic: char(1) vs varchar(1)
Replies: 1
Views: 702

char(1) vs varchar(1)

This regarding usage of data type Varchar and char for indicator columns . I did a sample test to check the bytes used for each data type and there is no difference between bytes used for char or varchar. Which data type occupies less space and is preferred for the usage where length is 1. create ta...
by sreediff
Mon Oct 10, 2016 4:36 am
Forum: General
Topic: vbr.py for copying tables between vertica servers
Replies: 1
Views: 1977

vbr.py for copying tables between vertica servers

i want to use vbr.py between two single nodes . What are settings needed in vbr.ini or custom ini.
Also what all files i need to copy to the target server . WIll restore command with ini file be safe and work without shutting down the target DB.

Go to advanced search