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.
Vertica is designed to operate with minimal configuration changes. Be careful to set and change configuration parameters according to documented guidelines.