Gokulakannan Somasundaram wrote:
Thanks Heikki. To clarify, there won't be any redirect-line pointers in this implementation. That space is saved. We will have the index tuple point to the latest live tuple in the update chain. So no need for redirect-line pointers.
The redirected line pointers are there for a reason. The reason is to be able to retail vacuum (= prune) a page without having to do a regular vacuum, scanning all indexes.
If you lose that ability, the idea is dead in the water. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq