| PostgreSQL 8.3.1 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.
Copyright © 2000-2009 Command Prompt, Inc. All Rights Reserved. All trademarks property of their respective owners.