FIVE POSTGRESQL QUERIES THAT DID MORE WORK THAN I ASKED FOR

Summary from the TLDR Data newsletter

Five PostgreSQL benchmarks show how unnecessary deduplication, CTE materialization, random sorting, extra column retrieval, and unindexed expressions can dramatically slow queries, with small SQL changes or a matching index delivering major speedups.