- Notifications
You must be signed in to change notification settings - Fork5
Commit14d02f0
committed
Rewrite the way GIN posting lists are packed on a page, to reduce WAL volume.
Inserting (in retail) into the new 9.4 format GIN posting tree created muchlarger WAL records than in 9.3. The previous strategy to WAL logging wasbasically to log the whole page on each change, with the exception ofcompletely unmodified segments up to the first modified one. That was nottoo bad when appending to the end of the page, as only the last segment hadto be WAL-logged, but per Fujii Masao's testing, even that produced 2x theWAL volume that 9.3 did.The new strategy is to keep track of changes to the posting lists in a morefine-grained fashion, and also make the repacking" code smarter to avoiddecoding and re-encoding segments unnecessarily.1 parent0cfa34c commit14d02f0
File tree
5 files changed
+666
-227
lines changed- src
- backend/access
- gin
- rmgrdesc
- include/access
5 files changed
+666
-227
lines changed0 commit comments
Comments
(0)