YMatrix
Quick Start
Connecting
Benchmarks
Deployment
Data Usage
Manage Clusters
Upgrade
Global Maintenance
Expansion
Monitoring
Security
Best Practice
Technical Principles
Data Type
Storage Engine
Execution Engine
Streaming Engine(Domino)
MARS3 Index
Extension
Advanced Features
Advanced Query
Federal Query
Grafana
Backup and Restore
Disaster Recovery
Guide
Performance Tuning
Troubleshooting
Tools
Configuration Parameters
SQL Reference
Restores the value of the system configuration parameter to the default value.
RESET configuration_parameter
RESET ALLRESET restores the system configuration parameters to their default values. RESET is an alternative writing method for SET configuration_parameter TO DEFAULT.
The default value is defined as the value that this parameter will have when it is not issued a SET for it in the current session. The actual source of this value may be the compiled default value, the main postgresql.conf configuration file, command line options, or the default settings per database or per user.
configuration_parameter
ALL
Set the statement_mem configuration parameter to its default value:
RESET statement_mem;RESET is a YMatrix database extension.