On Tue, Aug 26, 2025 at 2:11 PM Kirk Wolak <[email protected]> wrote: > I do have a question, one of the IDEAS we discussed was to ADD a new page > that combined the 2 pages.
Would the flow then be as follows? Please correct me if I'm wrong: Start: Parent page P, with adjacent child pages A -> B -> C -> D. Pages B and C are sparse enough and are about to be merged. 1: Acquire lock on pages B and C 2: Create a new page N, which copies the tuples in pages B and C 3: Acquire lock on parent page P, update the separator keys in P, release lock on P 4: Update pointers such that pages link like so: A -> N -> D 5: Release lock on pages B and C Regards, Madhav
