[rMBP]

I found this talk by Christophe Pettus [1] very informative. The title is somewhat misleading as most of the talk has little to do with Python, but it's a good introduction to more advanced Postgres concepts. Also available in PDF form [2].

[1] https://www.youtube.com/watch?v=0uCxLCmzaG4

[2] http://thebuild.com/presentations/pycon-2014-pppp.pdf