On Wed, Oct 19, 2016 at 2:04 PM, Bruce Momjian <br...@momjian.us> wrote:
>> What we should ask is what is the difference between indirect indexes
>> and WARM and to what extent they overlap.
>> My current understanding is that WARM won't help you if you update
>> parts of a JSON document and/or use GIN indexes, but is effective
>> without needing to add a new index type and will be faster for
>> retrieval than indirect indexes.
>> So everybody please chirp in with benefits or comparisons.
> I am not sure we have even explored all the limits of WARM with btree
> indexes --- I haven't heard anyone talk about non-btree indexes yet.

AFAIK there's no fundamental reason why it wouldn't work for other
index ams, but it does require quite a bit of legwork to get
everything working there.

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to