2min chapter

Postgres FM cover image

Queues in Postgres

Postgres FM

CHAPTER

How to Prevent Auto Vacuum From Deleting Tuples

I think this is slightly counterintuitive though, because I think some of the water vacuum settings, for example, are scale based. So each time we get an accumulation, we'll accumulate more in future unless we have a strategy for over time, getting rid of that bloat. Yeah, I mentioned this is it's looked like we have 1000 life rows, but the table size is 10 gigabytes. What 10 gigabytes for 1000 rows, what's happening here?Yeah, you shared with me that there's a really good blog post by Brenda about this specific issue. They argue at the end, that’s a really good reason to not have this in your main database and have

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