Up Against the WAL: The Write-Ahead Log in PostgreSQL
327 | Fri 01 Aug 11:45 a.m.–12:30 p.m.
Presented by
-
Christophe Pettus
@cep@fosstodon.org
@xof
https://thebuild.com
Christophe is the CEO of PGX Inc., a boutique PostgreSQL consultancy based in Alameda, California. He has been working with PostgreSQL since version 7, and databases for even longer.
Christophe Pettus
@cep@fosstodon.org
@xof
https://thebuild.com
Christophe is the CEO of PGX Inc., a boutique PostgreSQL consultancy based in Alameda, California. He has been working with PostgreSQL since version 7, and databases for even longer.
Abstract
The Write-Ahead Log in PostgreSQL underlies a huge number of features: crash recovery, binary replication, logical replication, and backups. This talk is a dive into the internals of the WAL, including its format, how it is written to storage, how it is used, and what to do when you get one of the many terrifying errors about WAL issues.
Videos
The Write-Ahead Log in PostgreSQL underlies a huge number of features: crash recovery, binary replication, logical replication, and backups. This talk is a dive into the internals of the WAL, including its format, how it is written to storage, how it is used, and what to do when you get one of the many terrifying errors about WAL issues.
Available sources: