AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
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,