Session

Back

Understanding Durability in Postgres

Date: 2016-09-15
Time: 10:30 - 11: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

Speaker

Andres Freund