Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> There's a note in the docs about this:
>> Note: Hash index operations are not presently WAL-logged, so hash indexes might need to be rebuilt with REINDEX
aftera database crash. For this reason, hash index use is presently discouraged.
> though it doesn't explicitly mention replication. Perhaps it should be
> updated to something like:
Yeah, I too just noticed that that caveat hadn't been updated.
> Note: Hash index operations are not presently WAL-logged, so hash
> indexes might need to be rebuilt with REINDEX after a database crash.
> They are also not replicated over streaming or file-based replication.
> For this reason, hash index use is presently discouraged.
s/this reason/these reasons/. Also maybe we should change this to a
<caution> or <warning> instead of just a <note>? Otherwise +1.
regards, tom lane