Append-only postings
Rewriting a blob to add a vector copies it, leaves garbage and needs a row lock. Instead each posting list is many rows with key (head id, sequence). An insert adds a row with a new increasing sequence. A read becomes a prefix range scan, and the rows are joined.