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.