Search found 17 matches

by sreediff
Tue Jun 20, 2017 9:09 pm
Forum: Vertica Database Administration
Topic: update statistics
Replies: 1
Views: 99

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: 4
Views: 742

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

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

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

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

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.
by sreediff
Mon Oct 10, 2016 4:34 am
Forum: General
Topic: Vertica copy on tables with identity columns
Replies: 3
Views: 623

Vertica copy on tables with identity columns

i created two tables CREATE TABLE TEST1 ( TEST1_ID identity(1) , CHART_TYPE_DESC varchar(100) NOT NULL, CREATED_BY_ID varchar(50), MODIFIED_BY_ID varchar(50) ); CREATE TABLE TEST2 ( TEST2_ID int , CHART_TYPE_DESC varchar(100) NOT NULL, CREATED_BY_ID varchar(50), MODIFIED_BY_ID varchar(50) ); When i ...

Go to advanced search