Hash indexes are not WAL logged in Postgres so they are not replicated and will ... | Hacker News

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

		koolba on March 20, 2017 \| parent \| context \| favorite \| on: Hash indexes are faster than btree indexes? 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 on March 20, 2017 [–]

Just to clarify, they are WAL logged starting in Postgres 10, which is what this article was talking about.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact