Re: Free space management within heap page - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Free space management within heap page
Date
Msg-id 45B5D668.5050406@enterprisedb.com
Whole thread Raw
In response to Re: Free space management within heap page  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
List pgsql-hackers
Pavan Deolasee wrote:
> One assumption I am  making here is that its sufficient to mark the line
> pointer
> "unused" (reset LP_USED flag) even though there is an index entry pointing
> to
> the tuple. During index scan, we anyways check for ItemIdIsUsed() before
> proceeding further. I know it might break the ctid chain, but does that
> really
> matter ? I don't see any reason why somebody would need to follow ctid 
> chain
> past a dead tuple.

You can't clear the LP_USED flag, but you could use the LP_DELETE flag 
that's currently not used in heap pages.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: ITAGAKI Takahiro
Date:
Subject: Re: Free space management within heap page
Next
From: Heikki Linnakangas
Date:
Subject: Re: Free space management within heap page