Managing Configuration Parameters: VSQL
You can configure all parameters at database scope. Some parameters can also be set and cleared at node and session scopes.
Caution: Vertica is designed to operate with minimal configuration changes. Be careful to set and change configuration parameters according to documented guidelines.