This short article explains a PostgreSQL optimization case.
This article enlists eight most dire SQL mistakes that often hamper database performance and suggests how to avoid them.