Postgres Professional
    Русский
    Русский
  • Postgres Pro DBMS
    • Postgres Pro Enterprise
    • Postgres Pro Standard
    • In clouds
    • Postgres Extensions
    • Development roadmap
  • Services
    • Database Technical support
    • Database Migration
    • Application Development
  • Education
  • Blog
  • About us
  • Contacts
  • PostgreSQL mailing list archive
  • Home
  • Documentation
  • Postgres Pro Standard 13
  • Download: 
    • epub
    • pdf
  • This page in other versions:
  • Postgres Pro Standard
    • 13
    • 12
    • 11
    • 10
    • 9.6
    • 9.5
    •  ( current ) 
  • Postgres Pro Enterprise
    • 13
    • 12
    • 11
    • 10
    • 9.6
  • PostgreSQL
    • 13
    • 12
    • 11
    • 10
    • 9.6
    • 9.5
    • 9.4
Chapter 14. Performance Tips
Prev UpPart II. The SQL LanguageHome Next

Chapter 14. Performance Tips

Table of Contents

14.1. Using EXPLAIN
14.1.1. EXPLAIN Basics
14.1.2. EXPLAIN ANALYZE
14.1.3. Caveats
14.2. Statistics Used by the Planner
14.2.1. Single-Column Statistics
14.2.2. Extended Statistics
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 max_wal_size
14.4.7. Disable WAL Archival and Streaming Replication
14.4.8. Run ANALYZE Afterwards
14.4.9. Some Notes about pg_dump
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 tuning Postgres Pro performance.


Prev Up Next
13.6. Locking and Indexes Home 14.1. Using EXPLAIN

© Postgres Professional Europe Limited, 2015 — 2021

info@postgrespro.com

Your message is accepted. The reference number is .