Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

No autovacuum? At reddit's scale I'm surprised you didn't run out of transaction IDs.


I 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.


Auto 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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: