Christophe Pettus - PostgreSQL Proficiency for Python People - PyCon 2016 on HackerTube: recommended by 3 Hacker News commenters across 3 separate months, 2016.
tutorial · intro · evergreen
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.
HN readers recommend it as a thorough, practical introduction to Postgres fundamentals and optimization for application developers.
“I found this to be great introductory that touches on all the major points to keep in mind with Postgres.”
3 Hacker News comments link this video. Each one links back to its thread.
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.
in “Things I Hate About PostgreSQL (2013)” · View on HN
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.
in “PG Casts – Postgres Screencasts” · View on HN
I recommend following Christophe Pettus - PostgreSQL Proficiency for Python People - PyCon 2016 video for postgresql basics and optimization ▶ this video
in “Practical Guide to PostgreSQL Optimizations” · View on HN