hash indexes tend to have really terrible write performance because the locations of the writes on disk are random. lsm trees have way better write performance.