Handling unique indexes on large data in PostgreSQL
A month ago, during a release to production, the feature I was working on failed to deploy due to a PostgreSQL restriction. It turned out to be a surprisingly fun and comprehensive learning moment.
Just because you’re getting an index scan, doesn't mean you can’t do better! - pgMustard
An issue I often see folks missing when reviewing query plans, is that they see that all of their scans involve indexes and they think that the query is likely already as fast (or efficient) as it can be. In this post we’ll look through several examples, some things to look out for, and how to then