
Development Versions: [devel](https://www.postgresql.org/docs/devel/performance-tips.html "PostgreSQL devel - Chapter 14. Performance Tips")

| Chapter 14. Performance Tips |
| --- |
| [Prev](https://www.postgresql.org/docs/current/locking-indexes.html "13.7. Locking and Indexes")  | [Up](https://www.postgresql.org/docs/current/sql.html "Part II. The SQL Language") | Part II. The SQL Language | [Home](https://www.postgresql.org/docs/current/index.html "PostgreSQL 18.3 Documentation") |  [Next](https://www.postgresql.org/docs/current/using-explain.html "14.1. Using EXPLAIN") |

* * *

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 PostgreSQL performance.
