PostgreSQL Internals

Architecture PostgreSQL uses shared memory to speed things up by avoiding unnecessary disk reads/writes. Inside shared memory, there are two important parts Shared Buffer Stores frequently accessed data blocks It reduces I/O Supports multiple use...