Schedule - PostgreSQL Development Conference 2024
Shaving off bytes at any scale: Space savings in various subsystems of PostgreSQL
Date: 2024-05-29
Time: 10:30–11:20
Room: Sauder(2270)
Level: Advanced
Most databases want to store data without losing it. However, there are various constraints (e.g. disk, memory, IO bandwidth, CPU time) that limit the amount of data you can store and access on a single system. Once you hit one of these constraints, you'll have to reduce usage of one of these metrics to remove that bottleneck and increase the performance of your system.
In this talk I'll cover the various subsystems inside PostgreSQL and explore the practical and less practical storage savings that we could realistically achieve.
