3 ms·
Hash indexes are not WAL logged in Postgres so they are not replicated and will not survive non-graceful shutdowns, i.e. if the server crashes you have to rebui
by koolba 10y ago
Hash indexes are not WAL logged in Postgres so they are not replicated and will not survive non-graceful shutdowns, i.e. if the server crashes you have to rebuild it from scratch. As such, they're not recommended unless you know exactly what you're doing.
- Tostino 10y agoJust to clarify, they are WAL logged starting in Postgres 10, which is what this article was talking about.