Hacker News new | ask | show | jobs
by fourseventy 231 days ago
I'm literally in the middle of upgrading my prod db to pg18. Its about 6tb, has a few thousand queries per second, should I be considering running in 'worker' mode instead of 'io_uring'?
2 comments

Why would you migrate your prod db if you aren't sure of all the changes and which config params to use?
For upgrades which have enough risks as it is, I would keep the number of variables low. Once upgraded and stable, you can replicate to a secondary instance with io_method switched and test on it before switching over.