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

I highly recommend using flexible-freeze if you run Postgres in production - does not take very much effort to set up and almost certainly will help you avoid issues with txnid wraparound:

https://github.com/pgexperts/flexible-freeze

It just runs `VACUUM FREEZE` when you schedule it (usually daily), starting with the tables closest to hitting a wraparound.



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

Search: