TOAST
Postgres FM
Postgres Data Storage and Toast
This chapter discusses the limitations on the size of data that can be stored in Postgres, the internal layout of pages, creating tables without columns, limitations on the number of columns and rows per page, and the concept of toast for storing oversized data. It also explores the performance implications of using default compression, selecting only necessary columns, and the use of 'select star'.
00:00
Transcript
Play full episode
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
