Schedule - PGConf.EU 2011

Synchronous Replication and Durability Tuning

Date: 2011-10-19
Time: 15:20–16:10
Room: Amsterdam 3
Level: Intermediate

One of the most anticipated features in PostgreSQL 9.1 is Synchronous Replication. PostgreSQL has always respected the durability aspects of ACID compliance. Extending that to reach onto multiple servers significantly expands the suitability of the database for business critical applications. And you only have to pay for its overhead when you need it.

The inevitable downside of Synchronous Replication is its impact on server commit speed. And recent trends in the database industry have proven some applications are willing to accept durability loss, when it must be sacrificed to reach performance goals.

But the innovative design used in PostgreSQL doesn't force you to make this sort of decision at the database level. Every individual commit can specify its durability requirements at any time--even in the middle of a transaction! Being able to classify your need at such a fine level allows PostgreSQL an unprecedented range of options in this area. Mission critical data that needs synchronous commit can coexist with high volume/best effort data, with each transaction fine-tuned to its position in the reliability vs. speed trade-off spectrum.

This talk will cover:

  • How Synchronous Replication is implemented in PostgreSQL 9.1
  • High Availability considerations when using Sync Rep
  • Available transaction level durability options, and their expected commit performance in common scenarios
  • Evaluating and improving the impact of latency on performance

Speaker

Greg Smith
Simon Riggs

Platinum Sponsor

EnterpriseDB

Gold Sponsors

EMC² Servoy VMWare

Silver Sponsors

2ndQuadrant Cybertec Dalibo Redpill Linpro