Re: MVCC doc improvements - Mailing list pgsql-patches

From Tom Lane
Subject Re: MVCC doc improvements
Date
Msg-id 8667.1040142956@sss.pgh.pa.us
Whole thread Raw
In response to MVCC doc improvements  (Neil Conway <neilc@samurai.com>)
Responses Re: MVCC doc improvements
List pgsql-patches
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

pgsql-patches by date:

Previous
From: Neil Conway
Date:
Subject: Re: documentation improvements
Next
From: Neil Conway
Date:
Subject: Re: MVCC doc improvements