This is another presentation from a core developer: https://momjian.us/main/writings/pgsql/optimizer.pdf