Dude, where's my byte?
Time: 11:30 - 12:20
Room: Market Street
In this documentary of the life-cycle of a single byte of data all the way from birth to purging, we attempt to demystify the internals of PostgreSQL's storage.
Along with the way we'll make checkpoints at various teachable checkpoints including but not limited to: Storage primitives - File structure - Heap - Block - Tuples - Pages Indices Caches MVCC & VACUUM Hardware & optimizations Uber's MySQL vs. PostgreSQL argument
The aim is to empower newer PostgreSQL users to develop mechanical sympathy for their installations in order to utilize and administer them in better ways.