2min chapter

Postgres FM cover image

Queues in Postgres

Postgres FM

CHAPTER

The Importance of Indexes in a TPS System

Pagerie pack is a valid solution for those who want to get rid of problem and continue working as nothing happened. But if you want to design the system to scale for really good TPS transactions per second, then union partitioning should be used. A good lesson can be learned from PGQ, from Skype, as I mentioned. It existed almost 20 years ago. They will go. You can run Pagerie pack against table and all it is indexes. The packing is better than vacuum full because it will lead to much various brief period of exclusive lock. So very, very brief and it's very graceful and so on. Vacuum full is a big hammer, of course,

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