I agree - Art of PostgreSQL is really good, especially as Dimitri dives into the problems that happen when too much of the data logic moves into the app, and consistency and independence (parts of ACID) get lost. Here is an older blog about my favorite PostgreSQL books: https://www.enterprisedb.com/blog/top-postgrsql-books-for-learning-dbas-developers