Beginner tips
Postgres FM
00:00
How to Optimize Your Postgres Database
Postgres 13 on D duplication and 14 on bottom up deletion has massively reduced this problem, but it still exists. If you're upgrading in a way that preserves your bloat Definitely worth looking into re-indexing as part of your what after your upgrade because you might get significant savings and speedups. I think not all beginners realize that the postgres documentation And release notes will be as good as they are. The comments in the source code is really accessible to even to beginners so those things are your friends when trying to work out why something's happening or what the truth should be.
Transcript
Play full episode
