Search found 18 matches

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

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

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

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

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

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

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

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