On Thu, Oct 20, 2016 at 12:14 PM, Petr Jelinek <p...@2ndquadrant.com> wrote: > WARM can do WARM update 50% of time, indirect index can do HOT update > 100% of time (provided the column is not changed), I don't see why we > could not have both solutions. > > That all being said, it would be interesting to hear Álvaro's thoughts > about which use-cases he expects indirect indexes to work better than WARM.
I'm not Alvaro, but it's quite evident that indirect indexes don't need space on the same page to get the benefits of HOT update (even though it wouldn't be HOT). That's a big difference IMO. That said, WARM isn't inherently limited to 50%, but it *is* limited to HOT-like updates (new tuple is in the same page as the old), and since in many cases that is a limiting factor for HOT updates, one can expect WARM will be equally limited. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
