Understanding Durability in Postgres

Date: 2016-09-15
Time: 15:30 - 16:20
Room: Ft. Worth 2
Level: Intermediate

Durability is an important concept in databases. In some workloads it also can be an expensive guarantee to make. For that reason postgres provides a fair amount of control about which actions are durable, and which are not.

We'll discuss: * Configuration of WAL logging * Unlogged tables * (A-)Synchronous Commit * Synchronous Replication, including the new options in 9.6 * Querying Replicas, with read-your-own-write guarantees

Potentially also: * Two-Phase Commit


Andres Freund