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.
Why Hacker News points people here: 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.”HN comment, 2016
“I highly recommend this tutorial by Christophe Pettus from PyCon”
Covers the basics of setting up Postgres and more.
Full comment
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.
Strongly recommendselmigrantoSep 2016
“I found this to be great introductory that touches on all the major points to keep in mind with Postgres.”
Great, up-to-date introduction covering vacuuming, MVCC, replication, and backups.
Full comment
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.
RecommendsceyhunkazelAug 2016
“I recommend following Christophe Pettus - PostgreSQL Proficiency for Python People - PyCon 2016 video for postgresql basics and optimization”
PostgreSQL basics and optimization.
Full comment
I recommend following Christophe Pettus - PostgreSQL Proficiency for Python People - PyCon 2016 video for postgresql basics and optimization this video