PostgreSQL Internals in Action: Shared Memory and Buffers

PostgreSQL uses shared memory to expedite access to the database by caching data in memory and to coordinate the execution of requests from multiple standalone Postgres backends/sessions. In this episode, we're looking into shared buffers, one of the areas of shared memory that holds table data for read and write operations.

0:00 Shared memory overview

5:43 Shared buffers in action

Want to reproduce all the steps on your end? Use this guide:

https://github.com/dmagda/DevMastersDb/blob/main/postgres/postgres_shared_buffers.md

Interested in diving deeper into databases? Stay connected with me here:

* Twitter: https://twitter.com/denismagda

* Medium: https://medium.com/@magda7817