The PostgreSQL database does a splendid job of managing your persistent data. It does so by using files on your regular file systems even. Ever wondered how PostgreSQL actually stores your data in tables? What about the indexes? Where and how are they stored?
This webinar explored how to understand the PostgreSQL table page layout better.
Additional topics covered were:
- How does PostgreSQL cope with large multi-GB sized tables?
- What happens when we do an INSERT, UPDATE or a DELETE on a row?
- How about large rows?
- How does TOAST work?