Christophe Pettus - PostgreSQL Proficiency for Python People - PyCon 2016

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.

I recommend following Christophe Pettus - PostgreSQL Proficiency for Python People - PyCon 2016 video for postgresql basics and optimization ▶ this video

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.