PostgreSQL Architecture

When working with PostgreSQL as a DBA, DevOps, or SRE, one of the most important concepts you’ll deal with is how PostgreSQL manages memory and disk I/O. Today, I explored shared buffers, dirty pages, checkpointers, and even ran some hands-on queries...