Why is Hash index not transaction safe.

Поиск
Список
Период
Сортировка
От Wei Shan
Тема Why is Hash index not transaction safe.
Дата
Msg-id CAFe9ZTpb+4G0sfBXApFpKs2ypuyQHPF-r899E+5jvfsx6uzvCw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Why is Hash index not transaction safe.  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Why is Hash index not transaction safe.  (Sameer Kumar <sameer.kumar@ashnik.com>)
Список pgsql-novice
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 по дате отправления:

Предыдущее
От: Felipe Santos
Дата:
Сообщение: Re: Using postgreSQL in our clinic
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Why is Hash index not transaction safe.