
PyCon 2016
3 HN recommenders · recommended in 3 months, 2016
3:00:06 · 7.8K views · May 30, 2016
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.
3 comments from Hacker News
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.
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.
I recommend following Christophe Pettus - PostgreSQL Proficiency for Python People - PyCon 2016 video for postgresql basics and optimization this video