Don't rely on IF NOT EXISTS for concurrent index creation in PostgreSQL
Link: https://www.shayon.dev/post/2024/225/stop-relying-on-if-not-exists-for-concurrent-index-creation-in-postgresql/
Discussion: https://news.ycombinator.com/item?id=41228022
#postgresql
Hacker News 50 /
npub1cp…xqmjn
2024-08-12 22:25:09
Author Public Key
npub1cp2rxt39auw2plhte4vqvgnp80kcrlkrreql2te85ezvny7dv7hqjxqmjnPublished at
2024-08-12 22:25:09Event JSON
{
"id": "232544bfa2b26df1d3fcf709c9dbf15ae5de52002c877dc471cee1a258e17384",
"pubkey": "c054332e25ef1ca0feebcd580622613bed81fec31e41f52f27a644c993cd67ae",
"created_at": 1723501509,
"kind": 1,
"tags": [
[
"t",
"postgresql"
],
[
"proxy",
"https://social.lansky.name/users/hn50/statuses/112951394905126215",
"activitypub"
]
],
"content": "Don't rely on IF NOT EXISTS for concurrent index creation in PostgreSQL\n\nLink: https://www.shayon.dev/post/2024/225/stop-relying-on-if-not-exists-for-concurrent-index-creation-in-postgresql/\nDiscussion: https://news.ycombinator.com/item?id=41228022\n\n#postgresql",
"sig": "ac29acf8bf7d8d8a875c61483934acfbda10bb801544f8de301a6666b130e8a0b7e14695cb2d102bac272153759f6f3dc1147dce2720665de5b4dcc02b30cba2"
}