Litestream author here. When a page gets full then it splits in two so each new mode has empty space for inserts and updates. That empty space compresses really

Litestream author here. When a page gets full then it splits in two so each new mode has empty space for inserts and updates. That empty space compresses really well. Also, OLTP data can have duplication when you have a categorical column that you haven’t moved into a separate table (eg a “type” column that has a couple unique values).