Advanced topics
Deep dives into PostgreSQL internals, extensions, and advanced features.
Guides by Category
Misc
Various advanced topics and techniques.
- Understanding how sparsely tuples are stored in a table - 8 min (beginner)
- How to understand LSN values and WAL filenames - 5 min (advanced)
- How to use OpenAI APIs right from Postgres to implement semantic search and GPT chat - 9 min (intermediate)
- How to install Postgres 16 with plpython3u: Recipes for macOS, Ubuntu, Debian, CentOS, Docker - 5 min (intermediate)
- How many tuples can be inserted in a page - 5 min (intermediate)
- How to estimate the YoY growth of a very large table using row creation timestamps and the planner statistics - 5 min (intermediate)
- How to find the best order of columns to save on storage ("Column Tetris") - 5 min (intermediate)
- How to help others - 5 min (beginner)
- How to work with metadata - 5 min (beginner)
- How to compile Postgres on Ubuntu 22.04 - 5 min (beginner)
Replication
Set up and manage PostgreSQL replication.
- How to convert a physical replica to logical - 5 min (intermediate)
- Postgres major upgrade without any downtime for a very large cluster running under heavy load - 5 min (advanced)
- How to troubleshoot streaming replication lag - 5 min (intermediate)