Enable wal_compression, make your server happier.
has measured positive effects
of setting "wal_compression = on" – first of all, benefits for the streaming replication gitlab.com/postgres-ai/te
Conversation
Worth noting that wal_compression can become a significant bottleneck in some workloads (e.g. VACUUMing a large table). Not an inherent issue, but the bad compression we still use for it. Should get better in 15, there's patches to make wal compression use lz4.
3
1
11
You’re unable to view this Tweet because this account owner limits who can view their Tweets. Learn more
Teach any code that deals with the fsm more about the logical database. Make extra fill factor space on each heap page truly reserved for updates. This avoids fragmentation.
Right now it's quite possible for VACUUM to remember that there is a bit of extra space in a page that it marks all-frozen right afterwards. It's a much broader problem then that, though. I like this example because it's an obviously pathological case. Holistic thinking needed.
2