Re: HOT documentation README - Mailing list pgsql-patches

From Gregory Stark
Subject Re: HOT documentation README
Date
Msg-id 87fy1u587a.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: HOT documentation README  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
List pgsql-patches
"Pavan Deolasee" <pavan.deolasee@gmail.com> writes:

> It would be worth mentioning that columns appearing in predicates
> of partial indexes and expressions of expression indexes are also
> checked. If any of these columns are changed, HOT update is not done.

In discussion a question arose. I don't think we currently compare these
columns before when we're building an index and find a visible hot update. We
just set hot_visible even if the chain might still be a valid hot chain for
the new index right? Should we consider checking the columns in that case too?
Or would it be too much extra overhead?

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com

pgsql-patches by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Re: Lazy xid assignment V4
Next
From: Tom Lane
Date:
Subject: Re: Lazy xid assignment V4