News for hackers. Stuff that matters.

A comment on Hash indexes are faster than btree indexes?. Parent comment

Re:Hash indexes are faster than btree indexes? by koolba on Monday March 20, 2017 @08:34AM (#13913534)
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.
[ Parent | on HN ]
Re:Hash indexes are faster than btree indexes? by Tostino on Monday March 20, 2017 @08:37AM (#13913560)
Just to clarify, they are WAL logged starting in Postgres 10, which is what this article was talking about.
[ Parent | on HN ]