TOAST
Postgres FM
00:00
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'.
Transcript
Play full episode
