3min chapter

Postgres FM cover image

Beginner tips

Postgres FM

CHAPTER

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.

00:00

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode