Re: Frequent Update Project: Design Overview of HOTUpdates - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Frequent Update Project: Design Overview of HOTUpdates
Date
Msg-id 1163112297.3634.570.camel@silverbirch.site
Whole thread Raw
In response to Re: Frequent Update Project: Design Overview of HOT Updates  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On Thu, 2006-11-09 at 13:21 -0800, Josh Berkus wrote:
> 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?"  

Very good. ;-)

Well, we had Overflow Update CHaining as an alternative name... :-)

The naming sounds silly, but we had a few alternate designs, so we
needed to be able to tell them apart sensibly. We've had TVR, SITC, UIP
and now HOT. Software research...

--  Simon Riggs              EnterpriseDB   http://www.enterprisedb.com




pgsql-hackers by date:

Previous
From: Mark Dilger
Date:
Subject: Re: plperl/plperlu interaction
Next
From: Tom Lane
Date:
Subject: Re: Introducing an advanced Frequent Update Optimization