4 ms·
No autovacuum? At reddit's scale I'm surprised you didn't run out of transaction IDs.
by FreakLegion 2y ago
No autovacuum? At reddit's scale I'm surprised you didn't run out of transaction IDs.
- gtaylor 2y agoAuto vacuuming is enabled now. We did have some near misses due to long running vacuums that barely completed before wraparounds, but got things tuned over time. I did none of that work but was on the team where it happened.
- jedberg 2y agoI turned it off because it would run at inopportune times. And we did run out of transaction IDs, which is why I was forced to do it. I never turned on the auto-vacuumer but I did set up a daily vacuum. Keep in mind I left Reddit 13 years ago and I’m sure they’ve made improvements since.