Get the latest tech news
Don't rely on IF NOT EXISTS for concurrent index creation in PostgreSQL
When you use `IF NOT EXISTS` and re-run your index creation, the task can silently complete while leaving behind an invalid index.
Stop Relying on IF NOT EXISTS for Concurrent Index Creation in PostgreSQL
Or read this on Hacker News
