Miscellaneous
Various advanced PostgreSQL topics including internals, extensions, and other specialized subjects.
Topics in this section
PostgreSQL Internals
- Understanding how sparsely tuples are stored in a table - 5 min (intermediate)
- How to understand LSN values and WAL filenames - 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 - 7 min (advanced)
- How to find the best order of columns to save on storage ("Column Tetris") - 5 min (intermediate)
Extensions and External Integrations
- How to use OpenAI APIs right from Postgres to implement semantic search and GPT chat - 9 min (intermediate)
How to help others
Difficulty: beginner • Time: 5 min
How to work with metadata
Difficulty: beginner • Time: 5 min
How to compile Postgres on Ubuntu 22.04
Difficulty: beginner • Time: 5 min