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: http://www.postgresql.org/mailpref/pgsql-hackers