Experts in Postgres and Open Source Infrastructure

24x7, 365 Enterprise services since 1997


The Write Ahead Log: Essentials

WAL (acronym for the Write Ahead Log) is the mechanism that Postgres uses to implement durability (the D in ACID) of data changes in the face of a system crash. WAL is also a critical component for Postgres to provide binary replication as well as online binary backups.

PostgreSQL mininum requirements

In this article we will be discussing the minimum requirements for production usage of PostgreSQL whether on-prem or in the cloud. We will not be discussing proprietary forks such as Amazon RDS or other Open Source forks such as Yugabyte or Greenplum.

PostgreSQL is the Linux of databases. It provides the kernel and key features to the most critical database services available today.