Postgres FM TOAST
Mar 3, 2023
Hussein Nasser talks about rows per page. Peter Zaitsev discusses Postgres TV. Topics include TOAST, data storage and limitations, LZ-Boys compression, toast limitations in PostgreSQL, optimizing column ordering, and exploring the impact of medium-size text in a database.
Chapters
Transcript
Episode notes
1 2 3 4 5 6
Introduction
00:00 • 2min
Postgres Data Storage and Toast
01:43 • 17min
LZ-Boys Compression and Trade-Offs
18:50 • 3min
Limits and limitations of toast in PostgreSQL
22:10 • 2min
Optimizing Column Ordering for Storage Efficiency in Postgres
23:50 • 2min
Exploring the Impact of Medium Size Text in a Database
26:03 • 2min