Durability in Postgres by Andres Freund

Wednesday, November 16 at 2:20-3:15

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 which actions are guaranteed to be durable.

We'll discuss:

  • Configuration of WAL logging
  • Unlogged tables
  • (A-)Synchronous Commit
  • Synchronous Replication, including the new options in 9.6
  • Querying Replicas, and read-your-own-write guarantees

About the speaker

Andres is a PostgreSQL committer and developer, focusing on replication, scalability and robustness. Before Citus Data he worked as a PostgreSQL Developer and Consultant at 2ndQuadrant and as a freelancing consultant in the areas of databases and software engineering. He has been developing Postgres and other Open Source projects since 2005.

Monday, September 12, 2016 - 12:00