I found a great sit pgcon.org which holds all conference slides dating back to year 2007. Where you can really
learn some stuff.
This slide Hack into the query optimizer by Tome Lane is really useful for all who want to grasp the basic ideas
behind the query optimizer.