PostgreSQL 9.0 High Performance

This one was super useful for me

https://www.amazon.es/PostgreSQL-High-Performance-Gregory-Sm...

I think that they have a newer edition for postgres 10

If high-performance PostgreSQL is critical to your job, here are some resources:

http://wiki.postgresql.org/wiki/Slow_Query_Questions

Query analysis tool http://explain.depesz.com

The mailing list http://www.postgresql.org/list/pgsql-performance/

Greg Smith's book http://www.amazon.com/PostgreSQL-High-Performance-Gregory-Sm...

#postgresql on freenode.net

They ink to PostgreSQL 9.0 High Performance (http://www.amazon.com/gp/product/184951030X/), which I agree is a great book if you're a sysadmin supporting PostgreSQL.

Yes, totally different thing. :-) A great book on query plan stuff is here:

http://www.amazon.com/PostgreSQL-High-Performance-Gregory-Sm...