See:

https://forum.vertica.com/discussion/23 ... -id#latest

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...

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 ...

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 ...

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...

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...

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...