PostgreSQL

Table of Contents

19.1. Setting Parameters

19.1.1. Parameter Names and Values

19.1.2. Parameter Interaction via the Configuration File

19.1.3. Parameter Interaction via SQL

19.1.4. Parameter Interaction via the Shell

19.1.5. Managing Configuration File Contents

19.2. File Locations

19.3. Connections and Authentication

19.3.1. Connection Settings

19.3.2. Security and Authentication

19.4. Resource Consumption

19.4.1. Memory

19.4.2. Disk

19.4.3. Kernel Resource Usage

19.4.4. Cost-based Vacuum Delay

19.4.5. Background Writer

19.4.6. Asynchronous Behavior

19.5. Write Ahead Log

19.5.1. Settings

19.5.2. Checkpoints

19.5.3. Archiving

19.6. Replication

19.6.1. Sending Server(s)

19.6.2. Master Server

19.6.3. Standby Servers

19.6.4. Subscribers

19.7. Query Planning

19.7.1. Planner Method Configuration

19.7.2. Planner Cost Constants

19.7.3. Genetic Query Optimizer

19.7.4. Other Planner Options

19.8. Error Reporting and Logging

19.8.1. Where To Log

19.8.2. When To Log

19.8.3. What To Log

19.8.4. Using CSV-Format Log Output

19.8.5. Process Title

19.9. Run-time Statistics

19.9.1. Query and Index Statistics Collector

19.9.2. Statistics Monitoring

19.10. Automatic Vacuuming

19.11. Client Connection Defaults

19.11.1. Statement Behavior

19.11.2. Locale and Formatting

19.11.3. Shared Library Preloading

19.11.4. Other Defaults

19.12. Lock Management

19.13. Version and Platform Compatibility

19.13.1. Previous PostgreSQL Versions

19.13.2. Platform and Client Compatibility

19.14. Error Handling

19.15. Preset Options

19.16. Customized Options

19.17. Developer Options

19.18. Short 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.

Privacy Policy | Code of Conduct | About PostgreSQL | Contact

Copyright © 1996-2023 The PostgreSQL Global Development Group