Documentation → PostgreSQL 8.4

Supported Versions: Current (17) / 16 / 15 / 14 / 13

Development Versions: devel

Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

PostgreSQL 8.4.22 Documentation
Prev	Fast Backward		Fast Forward	Next

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.4. Resource Consumption

18.4.1. Memory
18.4.2. Kernel Resource Usage
18.4.3. Cost-Based Vacuum Delay
18.4.4. Background Writer
18.4.5. Asynchronous Behavior

18.5. Write Ahead Log

18.5.1. Settings
18.5.2. Checkpoints
18.5.3. Archiving

18.6. Query Planning

18.6.1. Planner Method Configuration
18.6.2. Planner Cost Constants
18.6.3. Genetic Query Optimizer
18.6.4. Other Planner Options

18.7. Error Reporting and Logging

18.7.1. Where To Log
18.7.2. When To Log
18.7.3. What To Log
18.7.4. Using CSV-Format Log Output

18.8. Run-Time Statistics

18.8.1. Query and Index Statistics Collector
18.8.2. Statistics Monitoring

18.9. Automatic Vacuuming

18.10. Client Connection Defaults

18.10.1. Statement Behavior
18.10.2. Locale and Formatting
18.10.3. Other Defaults

18.11. Lock Management

18.12. Version and Platform Compatibility

18.12.1. Previous PostgreSQL Versions
18.12.2. Platform and Client Compatibility

18.13. Preset Options

18.14. Customized Options

18.15. Developer Options

18.16. 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 set configuration parameters. The subsequent sections discuss each parameter in detail.

Prev	Home	Next
Secure TCP/IP Connections with SSH Tunnels	Up	Setting Parameters