News for hackers. Stuff that matters.
Re:Hash indexes are faster than btree indexes? by jeltz on Monday March 20, 2017 @04:00PM (#13917193)
You get a warning when you try to create one in PostgreSQL 9.6. Maybe it should have been stronger worded, but since the issue is fixed in 10 anyway it is too late to do something about it.

    # CREATE INDEX ON t USING hash (id);
    WARNING:  hash indexes are not WAL-logged and their use is discouraged
    CREATE INDEX

There are no comments on this comment yet.