This one's great:

https://theartofpostgresql.com/

As a counterpoint, I did not like this book and learned much more efficiently from the postgres docs

Can you say what you didn't like about it? It's a little pricey so I would be curious to hear your feedback.

It's been a couple years but I found it very verbose and not very well edited. It may have improved since then. I did appreciate their push towards doing more in the DB and less in the app layer, though, and I wish more devs would hear that message!

1. Learn PostgreSQL: Build and manage high-performance database solutions using PostgreSQL 12 and 13 - Luca Ferrari, Enrico Pirozzi is current, and covers a lot of Postgres specific grounds in a structured manner. The examples are sometimes too succinct and hard to follow though, but I find it good for quickly looking things up, specifically the management side of things.

2. PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries - Henrietta Dombrovskaya, Boris Novikov, Anna Bailliekova is quite new, and exclusively focuses on query side of things, but goes deep into this topic. I haven't read it though, only flipped through the pages but it seems good.

I liked the o'Reilly book, Postgres: Up and Running approachable if you have some db experience. It is short and to the point.

I am also interested.