In Vertica a profile enforces password practices – how user passwords are created, reused, and validated. Benefits of using Profiles in Vertica Maintain database security by using password management features. To see the existing profiles on your database use the query bellow: [crayon-58dc8e9513904614948038/] by default a profile is created called default profile....

Continue reading

In Vertica we have the option to associate database objects with a specific storage location. This is very useful when you have different types of disks available on your Vertica Cluster hosts. Example: - imagine you have on your Vertica Cluster nodes SSD disks(fast disks) and some other...

Continue reading

In Vertica the Tuple Mover process is responsible for purging old data. The data that is eligible for purging will listen to the value that the HistoryRetentionTime parameter is set. The default value of this parameter is set to -1, this values tells Vertica that no deleted...

Continue reading
agent_oms

In Vertica we are able to manage and alter the parameters the database listen to. How to see the values of a parameter. Use the query bellow passing the name of the parameter. [crayon-58dc8e9515e21815459492/]  Or by using the SHOW CURRENT statement [crayon-58dc8e9515e29924791851/]   How to alter the value of a parameter Base Syntax: [crayon-58dc8e9515e2e736664070/]   Example...

Continue reading

Recently i have setup a Vertica Cluster and faced some ssh connection laziness, for no reason my ssh connection took like 5 to 10 seconds to complete. After some "debugging" online i have found a cool solution for the problem. It is actually a parameter...

Continue reading

The dbadmin user must have full privileges on the directory in order to create the location. Syntax: [crayon-58dc8e9517392299313978/] First create the directory on the host and give ownership to the dbadmin and his group. [crayon-58dc8e951739a028590506/]  Create  the storage location inside the database [crayon-58dc8e951739f377688536/]   Check the locations [crayon-58dc8e95173a3045489192/] Measure the location performance Important to know that...

Continue reading