Postgres Internals Hiding in Plain Sight | Crunchy Data Blog
www.crunchydata.com
Get under the hood of Postgres by looking at psql, system views, and internal tables.