PostgreSQL Tutorial: Performance optimization
This chapter explains how to optimize PostgreSQL performance and provides examples.
PostgreSQL Tutorial: Enabling Linux Huge Pages
Summary: Using Huge Pages reduces the memory page table size of PostgreSQL processes and cuts down CPU overhead spent on memory management, thereby improving overall database performance.
PostgreSQL Tutorial: Tuning I/O Performance with pg_stat_io
Summary: In this tutorial, you will learn about pg_stat_io view, including byte-level I/O statistics, WAL tracking, and comprehensive real-world use cases for better database performance tuning.
PostgreSQL Tutorial: Partitioned table statistics
Summary: in this tutorial, you will learn how PostgreSQL collects partitioned table statistics and how they affect PostgreSQL’s estimates.
PostgreSQL Tutorial: Row count estimates in EXPLAIN
Summary: in this tutorial, you will learn what’s ’estimated rows’ in EXPLAIN output all about.
PostgreSQL Tutorial: Common queries with pg_stat_statements
Summary: In this tutorial, we will give some example queries you can use with pg_stat_statements as a starting point for different challenges.
PostgreSQL Tutorial: Tuning work_mem setting
Summary: in this tutorial, you will learn how to tune work_mem setting in PostgreSQL.
PostgreSQL Tutorial: EXPLAIN Scan Nodes (2)
Summary: In this tutorial, you will learn various types of scan “nodes” / operations that you might see in explain plans.
PostgreSQL Tutorial: Tune query with EXPLAIN BUFFERS
Summary: in this tutorial, you will learn how to tune query with EXPLAIN BUFFERS in PostgreSQL.
PostgreSQL Tutorial: EXPLAIN Query Plan Fields Glossary
Summary: In this tutorial, you will learn various basic fields that you might see in explain plans.