Christophe Pettus - PostgreSQL Proficiency for Python People - PyCon 2016
Why Hacker News recommends it
HN readers recommend it as a thorough, practical introduction to Postgres fundamentals and optimization for application developers.
What it is
A three-hour PyCon 2016 tutorial by Christophe Pettus that orients Python developers to PostgreSQL. It covers installation, administration, and use, including vacuuming, MVCC, replication and backups.
Recommended by 3 HN commenters across 3 different months, 2016 to 2016.
What Hacker News said
Strong rec insertnickname · 2016-06 · on “PG Casts – Postgres Screencasts”
For this, I highly recommend this tutorial by Christophe Pettus from PyCon: [this video] It covers the basics of setting up Postgres as well as other things.
Strong rec elmigranto · 2016-09 · on “Things I Hate About PostgreSQL (2013)”
I found this to be great introductory that touches on all the major points to keep in mind with Postgres. It's pretty up-to-date too! [this video] It isn't quite what you ask for, but should be enough to get you high-level overview of major systems and contains solid practical advices (on vacuuming, mvcc, replication, backups, etc…), so you know what to google for deeper understanding.
Recommends ceyhunkazel · 2016-08 · on “Practical Guide to PostgreSQL Optimizations”
I recommend following Christophe Pettus - PostgreSQL Proficiency for Python People - PyCon 2016 video for postgresql basics and optimization [this video]