Search found 1738 matches

by JimKnicely
Thu Jun 29, 2017 2:56 pm
Forum: Vertica Database Administration
Topic: update statistics
Replies: 1
Views: 90

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

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 ...
by JimKnicely
Thu Jun 15, 2017 2:19 pm
Forum: Vertica Links
Topic: Understanding Users, Privileges, and Roles
Replies: 0
Views: 90

Understanding Users, Privileges, and Roles

Another great Vertica Blog post "Understanding Users, Privileges, and Roles" by Soniya! Every Vertica database has one or more users. When users connect to the database, they log in with credentials that a superuser defines. Database users should only have access to the database resources they need ...
by JimKnicely
Thu Jun 15, 2017 2:16 pm
Forum: Vertica Links
Topic: In-Database Approximate Median and Percentile Functions
Replies: 0
Views: 90

In-Database Approximate Median and Percentile Functions

New Vertica blog post authored by Ginger Ni ! Median and percentile functions are commonly used data statistic functions. They are also used in other sophisticated data analysis algorithms, such as the robust z-Score normalization function. Vertica has exact MEDIAN and PERCENTILE_CONT functions, but...
by JimKnicely
Wed Jun 14, 2017 7:48 pm
Forum: Vertica Error Codes
Topic: Unable to create DB: Error : 127.0.0.1 Permission Denied
Replies: 3
Views: 188

Re: Unable to create DB: Error : 127.0.0.1 Permission Denied

Hi, Check the [nodes] section of your /opt/vertica/config/admintools.conf file. You should see an entry like this: [Nodes] node0001 = 127.0.0.1,/d2/vertica,/d2/vertica If you see this, then something went wrong with the install... [Nodes] node0001 = 127.0.0.1,/home/dbadmin,/home/dbadmin If you haven...
by JimKnicely
Sat Jun 10, 2017 2:07 am
Forum: Vertica Links
Topic: Vertica OEM Hardware Sizing Guide
Replies: 0
Views: 148

Vertica OEM Hardware Sizing Guide

Vertica is a massively parallel processing (MPP) database designed to run across a cluster of similar nodes. These nodes should be identical. However, in some cases that is not possible. For example, if you expand a cluster that was originally purchased more than two years prior,the nodes are proba...

Go to advanced search