Search found 18 matches
- Tue Jul 25, 2017 10:15 pm
- Forum: Vertica Database Administration
- Topic: change ip address
- Replies: 7
- Views: 37976
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.
- Tue Jun 20, 2017 9:09 pm
- Forum: Vertica Database Administration
- Topic: update statistics
- Replies: 1
- Views: 17901
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...
- Tue Jun 20, 2017 9:04 pm
- Forum: Vertica Database Administration
- Topic: change ip address
- Replies: 7
- Views: 37976
Re: change ip address
will try on a local vm copy first.
- Fri Nov 18, 2016 1:39 pm
- Forum: General
- Topic: vertica 7.2.3 community edition
- Replies: 1
- Views: 6416
vertica 7.2.3 community edition
where to download 7.2.3 version for red hat 7.
- Fri Nov 18, 2016 1:38 pm
- Forum: General
- Topic: Vertica community edition download
- Replies: 1
- Views: 8002
Vertica community edition download
where to download vertica 7.2.3 community edition ? I can see community edition for vertica 8.0 only
- Wed Oct 19, 2016 8:20 am
- Forum: Vertica Database Development
- Topic: char(1) vs varchar(1)
- Replies: 1
- Views: 17303
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...
- Mon Oct 10, 2016 4:36 am
- Forum: General
- Topic: vbr.py for copying tables between vertica servers
- Replies: 1
- Views: 7480
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.
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.