It's dangerous to go alone. Take this for all things Postgres.
It’s a long talk, but he talks about almost everything there is to know about Postgres. For advanced stuff he gives just enough starting points for figuring it out yourself.
Watch out! The slides links in the video description don’t work. But you can find them on thebuild.com.