Login
From:
Shayon Mukherjee
(Uncensored)
subscribe
Stop Relying on IF NOT EXISTS for Concurrent Index Creation in PostgreSQL
https://www.shayon.dev/post/2024/225/stop-relying-on-if-not-exists-for-concurrent-index-creation-in-postgresql/
links
backlinks
Tagged with:
tech
rails
database
postgresql
foreign keys
When you use `IF NOT EXISTS` and re-run your index creation, the task can silently complete while leaving behind an invalid index.
Roast topics
Find topics
Find it!
