Postgres Pro
Downloads
Home   >   mailing lists

Why is Hash index not transaction safe. - Mailing list pgsql-novice

From Wei Shan
Subject Why is Hash index not transaction safe.
Date
Msg-id CAFe9ZTpb+4G0sfBXApFpKs2ypuyQHPF-r899E+5jvfsx6uzvCw@mail.gmail.com
Whole thread Raw
Responses Re: Why is Hash index not transaction safe.
Re: Why is Hash index not transaction safe.
List pgsql-novice
Tree view
Hi all,

I read the following about Hash indexes in Heroku's blog (https://devcenter.heroku.com/articles/postgresql-indexes)

Hash Indexes are only useful for equality comparisons, but you pretty much never want to use them since they are not transaction safe, need to be manually rebuilt after crashes, and are not replicated to followers, so the advantage over using a B-Tree is rather small.

Could anyone explain about why is it not transaction safe as compared to B-Tree index.

Thanks!
--
Regards,
Ang Wei Shan

pgsql-novice by date:

Previous
From: Felipe Santos
Date:
Subject: Re: Using postgreSQL in our clinic
Next
From: Tom Lane
Date:
Subject: Re: Why is Hash index not transaction safe.