AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
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'.