Simon,
> If we perform an update that meets the HOT criteria then we put the
> new version into the overflow relation; we describe this as a HOT
> UPDATE. If we perform an update that does not meet the criteria, then we
> carry on with the existing/old MVCC behaviour; we describe this as a
> non-HOT UPDATE.
Making the essential performance analysis question, "Am I HOT or Not?"
Sorry, but someone had to say it. ;-)
--
--Josh
Josh Berkus
PostgreSQL @ Sun
San Francisco