3 ms·
One thing that I really wish existed was a comprehensive guide to vacuuming, transaction id wraparound and similar issues. There have been a few posts recently
by hyperpape 10y ago
One thing that I really wish existed was a comprehensive guide to vacuuming, transaction id wraparound and similar issues. There have been a few posts recently that discussed problems that arise, but what I haven't seen is a sort of comprehensive "here are the issues that exist, here is what you must monitor in order to be safe" type of guide. The official docs are helpful, but fall short of that kind of guide, and none of the posts I've seen are really comprehensive.
Unfortunately, I'm pretty new to postgres and can't write it myself.
- elmigranto 10y agoI found this to be great introductory that touches on all the major points to keep in mind with Postgres. It's pretty up-to-date too! https://www.youtube.com/watch?v=knUitQQnpJo https://www.youtube.com/watch?v=knUitQQnpJo It isn't quite what you ask for, but should be enough to get you high-level overview of major systems and contains solid practical advices (on vacuuming, mvcc, replication, backups, etc…), so you know what to google for deeper understanding.
- hyperpape 10y agoThanks! It's too long for me to watch right now, but I've saved it for the next time I can dedicate that much time to a video.
- elmigranto 10y agoFeel free to skip to any topic, it is quite well structured to do that.