The adoption of PostgreSQL is growing each year. Many people coming to PostgreSQL are often coming from other
relational databases, with assumptions of how relational databases work. Although PostgreSQL may feel very familiar to these
people, it is different enough to cause some misunderstandings which lead to bad and slow queries.
There are also people coming often from only programming backgrounds, who assume data processing in SQL is much like
data processing in any language. For these two groups of folks, I think the
new book written by EDB and 2nd Quadrant Author, Jimmy Angelakos, "PostgreSQL Mistakes and How To Avoid Them" will save them a lot of miss-steps.