As a long-time and fairly technical MySQL user and only light experience with PostgreSQL, can you suggest the best reading material (in addition to the user manual) on the subject?

Comparatively, for MySQL, my recommendation would be 'High Performance MySQL'.