Chapter 18. Server Configuration
- Table of Contents
- 18.1. Setting Parameters
- 18.2. File Locations
- 18.3. Connections and Authentication
- 18.3.1. Connection Settings
- 18.3.2. Security and Authentication
- 18.3.1. Connection Settings
- 18.4. Resource Consumption
- 18.4.1. Memory
- 18.4.2. Disk
- 18.4.3. Kernel Resource Usage
- 18.4.4. Cost-based Vacuum Delay
- 18.4.5. Background Writer
- 18.4.6. Asynchronous Behavior
- 18.4.2. Disk
- 18.4.1. Memory
- 18.5. Write Ahead Log
- 18.5.1. Settings
- 18.5.2. Checkpoints
- 18.5.3. Archiving
- 18.5.2. Checkpoints
- 18.5.1. Settings
- 18.6. Replication
- 18.6.1. Sending Server(s)
- 18.6.2. Master Server
- 18.6.3. Standby Servers
- 18.6.2. Master Server
- 18.6.1. Sending Server(s)
- 18.7. Query Planning
- 18.7.1. Planner Method Configuration
- 18.7.2. Planner Cost Constants
- 18.7.3. Genetic Query Optimizer
- 18.7.4. Other Planner Options
- 18.7.2. Planner Cost Constants
- 18.7.1. Planner Method Configuration
- 18.8. Error Reporting and Logging
- 18.8.1. Where To Log
- 18.8.2. When To Log
- 18.8.3. What To Log
- 18.8.4. Using CSV-Format Log Output
- 18.8.2. When To Log
- 18.8.1. Where To Log
- 18.9. Run-time Statistics
- 18.9.1. Query and Index Statistics Collector
- 18.9.2. Statistics Monitoring
- 18.9.1. Query and Index Statistics Collector
- 18.10. Automatic Vacuuming
- 18.11. Client Connection Defaults
- 18.11.1. Statement Behavior
- 18.11.2. Locale and Formatting
- 18.11.3. Shared Library Preloading
- 18.11.4. Other Defaults
- 18.11.2. Locale and Formatting
- 18.11.1. Statement Behavior
- 18.12. Lock Management
- 18.13. Version and Platform Compatibility
- 18.13.1. Previous PostgreSQL Versions
- 18.13.2. Platform and Client Compatibility
- 18.13.1. Previous PostgreSQL Versions
- 18.14. Error Handling
- 18.15. Preset Options
- 18.16. Customized Options
- 18.17. Developer Options
- 18.18. Short Options
- 18.15. Preset Options
There are many configuration parameters that affect the behavior of the database system. In the first section of this chapter we describe how to interact with configuration parameters. The subsequent sections discuss each parameter in detail.