The Hidden Memory Killer (PostgreSQL TOAST) скачать в хорошем качестве

The Hidden Memory Killer (PostgreSQL TOAST)

PostgreSQL has a secret mechanism for handling large data called TOAST (The Oversized-Attribute Storage Technique). It keeps your tables small and your queries fast... until it doesn't. In this video, we dive into the architecture of PostgreSQL to prove exactly how TOAST works and reveal a "Compression Trap" that fools most developers. What you'll learn: How PostgreSQL stores data larger than 8kB pages. The difference between EXTENDED and EXTERNAL storage strategies. The "Compression Trap": Why your huge data might still be sitting in the main table. A live demo proving that accessing TOASTed data can be 2,500x more expensive than normal reads. Why SELECT * is a memory killer in production.