The article discusses a critical incident involving Postgres indexing at a high-volume database with billions of rows. It highlights the potential pitfalls of concurrent indexing, which can fail silently and lead to performance issues. The author shares best practices for Postgres indexing, including using the CONCURRENTLY flag, monitoring index creation, validating indexes manually, and properly handling partitioned tables.

https://blog.bemi.io/indexing/