Configuration Parameters
Configuration parameters are settings that affect database behavior. You can use configuration parameters to enable, disable, or tune features related to different database aspects like Tuple Mover, security, Database Designer, or projections. Configuration parameters have default values, stored in the Vertica database.
You can modify certain parameters to configure your Vertica database in two ways:
- Management Console browser-based interface
- VSQL statements
Before you modify a database parameter, review all documentation about the parameter to determine the context under which you can change it. Some parameter changes require a database restarrt to take effect. The CHANGE_REQUIRES_RESTART
column in the system table CONFIGURATION_PARAMETERS
indicates whether a parameter requires a restart. You can also query CONFIGURATION_PARAMETERS
to determine what levels (node, session, database) are valid for a given parameter.