Documentation → PostgreSQL 8.2

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.2.23 Documentation
Prev	Fast Backward		Fast Forward	Next

Chapter 17. Server Configuration

Table of Contents

17.1. Setting Parameters

17.2. File Locations

17.3. Connections and Authentication

17.3.1. Connection Settings
17.3.2. Security and Authentication

17.4. Resource Consumption

17.4.1. Memory
17.4.2. Free Space Map
17.4.3. Kernel Resource Usage
17.4.4. Cost-Based Vacuum Delay
17.4.5. Background Writer

17.5. Write Ahead Log

17.5.1. Settings
17.5.2. Checkpoints
17.5.3. Archiving

17.6. Query Planning

17.6.1. Planner Method Configuration
17.6.2. Planner Cost Constants
17.6.3. Genetic Query Optimizer
17.6.4. Other Planner Options

17.7. Error Reporting and Logging

17.7.1. Where To Log
17.7.2. When To Log
17.7.3. What To Log

17.8. Run-Time Statistics

17.8.1. Query and Index Statistics Collector
17.8.2. Statistics Monitoring

17.9. Automatic Vacuuming

17.10. Client Connection Defaults

17.10.1. Statement Behavior
17.10.2. Locale and Formatting
17.10.3. Other Defaults

17.11. Lock Management

17.12. Version and Platform Compatibility

17.12.1. Previous PostgreSQL Versions
17.12.2. Platform and Client Compatibility

17.13. Preset Options

17.14. Customized Options

17.15. Developer Options

17.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