Christophe Pettus - PostgreSQL Proficiency for Python People - PyCon 2016

PyCon 20163 HN recommenders · 2016–2016
8K views · tutorial · evergreen · Uploaded 2016-05-30

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.

Watch on YouTube

3 comments from Hacker News

@insertnickname2016 · in “PG Casts – Postgres Screencasts”

For this, I highly recommend this tutorial by Christophe Pettus from PyCon: [VIDEO] It covers the basics of setting up Postgres as well as other things.

Strongly recommendsView on HN
@ceyhunkazel2016 · in “Practical Guide to PostgreSQL Optimizations”

I recommend following Christophe Pettus - PostgreSQL Proficiency for Python People - PyCon 2016 video for postgresql basics and optimization [VIDEO]

RecommendsView on HN
@elmigranto2016 · in “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! [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.

Strongly recommendsView on HN