Re: HOT for PostgreSQL 8.3 - Mailing list pgsql-hackers

From Zeugswetter Andreas ADI SD
Subject Re: HOT for PostgreSQL 8.3
Date
Msg-id E1539E0ED7043848906A8FF995BDA57901C13BEA@m0143.s-mxs.net
Whole thread Raw
In response to Re: HOT for PostgreSQL 8.3  (Hannu Krosing <hannu@skype.net>)
Responses Re: HOT for PostgreSQL 8.3  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
List pgsql-hackers
> > As described, you've made
> > that problem worse because you're trying to say we don't know which
of
> > the chain entries is pointed at.
>
> There should be a flag, say HOT_CHAIN_ENTRY for the tuple the

it's called HEAP_UPDATE_ROOT

> index(es) point at. And this should be the preferred CTID for
> inserting new versions once the old one is dead.

This is not possible, see my reply to Bruce (maybe unless the whole hot
chain is dead).
(because that would need a back pointer, so readers arriving at the root
find the visible tuple)

Andreas


pgsql-hackers by date:

Previous
From: "Pavan Deolasee"
Date:
Subject: Re: HOT for PostgreSQL 8.3
Next
From: "Pavan Deolasee"
Date:
Subject: Re: HOT for PostgreSQL 8.3