Category: PostgreSQL

In a previous article we have analyzed the architecture of Oracle Database (SGA/PGA). This time we will look at the memory architecture of PostgreSQL and the key parameters for optimal performance. The memory model of PostgreSQL differs significantly from that of… read more

In this article we will look at the mechanism that connects memory to disk and ensures that we will not lose data if the database goes down (e.g. due to power failure): Write-Ahead Logs (WAL) and Checkpoints. When we execute… read more

In this article we will see how PostgreSQL manages concurrent access through MVCC, what Bloat is, what Data Churn is, what Vacuum is, and how to properly configure it with Autovacuum. What is… read more