I found this recent book by one of the Postgres contributors helpful: https://masteringpostgresql.com/