Do what is the recovery/restart process for a partially created index? And how d... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		whartung on Aug 12, 2024 \| parent \| context \| favorite \| on: Don't rely on IF NOT EXISTS for concurrent index c... Do what is the recovery/restart process for a partially created index? And how do you clean up after an aborted index build?

asabil on Aug 12, 2024 [–]

REINDEX INDEX CONCURRENTLY[1]

[1]: https://www.postgresql.org/docs/current/sql-reindex.html

Consider applying for YC's Summer 2026 batch! Applications are open till May 4
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact