Managing the Vertica database parameters

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.

 Or by using the SHOW CURRENT statement


How to alter the value of a parameter

Base Syntax:


Example of altering the AdvanceAHMInterval to 200 secounds


Also we have the option to clear the value of a parameter, this will statement will set the parameter value to its default value.

Base Syntax:

Example :



I hope this was helpful and i appreciate if you would like, subscribe or share our posts. I it is just a click


No Comments
Leave a Comment

%d bloggers like this: