Bruce Momjian wrote: > Well, let's walk through this. Let's suppose you have three updates > that stay on the same page and don't update any indexed columns --- that > would produce a HOT chain of four tuples. If you then do an update that > changes an indexed column, prior to this patch, you get a normal update, > and more HOT updates can be added to this. With WARM, we can join those > chains
With WARM, what happens is that the first three updates are HOT updates just like currently, and the fourth one is a WARM update. > and potentially trim the first HOT chain as those tuples become > invisible. That can already happen even without WARM, no? -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers