On 6/23/2006 3:10 PM, Mark Woodward wrote:
This is NOT an "in-place" update. The whole MVCC strategy of keeping old versions around doesn't change. The only thing that does change is one level of indirection. Rather than keep references to all versions of all rows in indexes, keep only a reference to the first or "key" row of each row, and have the first version of a row form the head of a linked list to subsequent versions of each row. The list will be in decending order.
Where exactly do you intend to keep all those links (for a table with N indexes)?
Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] # ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster