That's a pretty good article about some patterns that I reckon we need everytime

A high-level overview of how PostgreSQL stores data on disk, covering segments, pages and more.

A bunch of tips for using PostgreSQL