When it comes to database optimization, developers often reach for the same old tools: rewrite the query slightly differently, slap an index on a column, denormalize, analyze, vacuum, cluster, repeat. Conventional techniques are effective, but sometimes being creative can really pay off!

In which I show how ElasticSearch, Solr or another search specific database is probably unnecessary for a lot of PostgreSQL users.