Chapter 14. Performance Tips
- Table of Contents
- 14.1.UsingEXPLAIN
- 14.1.1.EXPLAIN Basics
- 14.1.2.EXPLAIN ANALYZE
- 14.1.3.Caveats
- 14.1.2.EXPLAIN ANALYZE
- 14.1.1.EXPLAIN Basics
- 14.2.Statistics Used by the Planner
- 14.3.Controlling the Planner with ExplicitJOIN Clauses
- 14.4.Populating a Database
- 14.3.Controlling the Planner with ExplicitJOIN Clauses
- 14.4.1.Disable Autocommit
- 14.4.2.UseCOPY
- 14.4.3.Remove Indexes
- 14.4.4.Remove Foreign Key Constraints
- 14.4.5.Increasemaintenance_work_mem
- 14.4.6.Increasecheckpoint_segments
- 14.4.7.Disable WAL Archival and Streaming Replication
- 14.4.8.RunANALYZE Afterwards
- 14.4.9.Some Notes Aboutpg_dump
- 14.4.2.UseCOPY
- 14.4.1.Disable Autocommit
- 14.5.Non-Durable Settings
Query performance can be affected by many things. Some of these can be controlled by the user, while others are fundamental to the underlying design of the system. This chapter provides some hints about understanding and tuningPostgreSQL performance.