September 4, 2025: PostgreSQL 18 RC 1 Released!

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

Development Versions: 18 / 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.3.23 Documentation
Prev	Fast Backward	Fast Forward	Next

Chapter 14. Performance Tips

Table of Contents

14.1. Using EXPLAIN

14.2. Statistics Used by the Planner

14.3. Controlling the Planner with Explicit JOIN Clauses

14.4. Populating a Database

14.4.1. Disable Autocommit
14.4.2. Use COPY
14.4.3. Remove Indexes
14.4.4. Remove Foreign Key Constraints
14.4.5. Increase maintenance_work_mem
14.4.6. Increase checkpoint_segments
14.4.7. Turn off archive_mode
14.4.8. Run ANALYZE Afterwards
14.4.9. Some Notes About pg_dump

Query performance can be affected by many things. Some of these can be manipulated by the user, while others are fundamental to the underlying design of the system. This chapter provides some hints about understanding and tuning PostgreSQL performance.

Prev	Home	Next
Locking and Indexes	Up	Using `EXPLAIN`