Neil Conway <neilc@samurai.com> writes:
> This patch improves the MVCC documentation: I added some additional
> discussion of deadlock conditions, removed a mis-statement about index
> locking, and made minor edits in a couple other places.
> - </para>
> -
> - <para>
> - In short, B-tree indexes are the recommended index type for concurrent
> - applications.
> </para>
AFAICS, that is not a misstatement. B-trees are still the only
recommended index type for concurrent-update situations ...
hash has deadlock issues and the other two are just plain not
concurrent.
regards, tom lane