Greg Smith: Synchronous Replication and Durability Tuning

diff --git a/media/PgConfEu2011-sync_replication/hCalendar.html b/media/PgConfEu2011-sync_replication/hCalendar.html
new file mode 100644 (file)
index 0000000..d44fb01
--- /dev/null
+++ b/media/PgConfEu2011-sync_replication/hCalendar.html
@@ -0,0 +1,29 @@
+<!-- http://microformats.org/wiki/hcalendar-cheatsheet -->
+<div class="vevent">
+ <span class="organiser">
+Greg Smith
+ </span>
+ <span class="summary">
+Synchronous Replication and Durability Tuning
+ </span>
+ <a class="url" href="http://www.postgresql.eu/events/schedule/pgconfeu2011/session/156-synchronous-replication-and-durability-tuning/">PGConf.EU 2011</a>,
+ <span class="location">Amsterdam</span>,
+ <abbr class="dtstart" title="20111027">Oct. 19, 2011</abbr>
+ <div class="description">
+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.
+<p>
+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.
+<p>
+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.
+<p>
+This talk will cover:
+
+<ul>
+<li>How Synchronous Replication is implemented in PostgreSQL 9.1
+<li>High Availability considerations when using Sync Rep
+<li>Available transaction level durability options, and their expected commit performance in common scenarios
+<li>Evaluating and improving the impact of latency on performance
+</ul>
+
+ </div>
+</div>

diff --git a/media/PgConfEu2011-sync_replication/presentation.pdf b/media/PgConfEu2011-sync_replication/presentation.pdf
new file mode 120000 (symlink)
index 0000000..6038d31
--- /dev/null
+++ b/media/PgConfEu2011-sync_replication/presentation.pdf
@@ -0,0 +1 @@
+SyncRepDurability.pdf
\ No newline at end of file

diff --git a/media/PgConfEu2011-sync_replication/video.ogv b/media/PgConfEu2011-sync_replication/video.ogv
new file mode 120000 (symlink)
index 0000000..9afe52f
--- /dev/null
+++ b/media/PgConfEu2011-sync_replication/video.ogv
@@ -0,0 +1 @@
+SynchronousReplicationandDurabilityTuningGregSmithCOTILLION91511.webm
\ No newline at end of file

diff --git a/media/PgConfEu2011-sync_replication/video.srt.yaml b/media/PgConfEu2011-sync_replication/video.srt.yaml
new file mode 100644 (file)
index 0000000..66668ab
--- /dev/null
+++ b/media/PgConfEu2011-sync_replication/video.srt.yaml
@@ -0,0 +1,76 @@
+--- 
+- '1.4'
+- '2.4'
+- "[1] Synchronous Replication and Durability Tuning"
+--- 
+- '45.5'
+- '46.5'
+- "[2] Synchronous Replication"
+--- 
+- '143.5'
+- '144.5'
+- "[3] Target Cluster Architecture"
+--- 
+- '274.6'
+- '275.6'
+- "[4] Setup progression"
+--- 
+- '373.4'
+- '374.4'
+- "[5] synchronous_standby_names"
+--- 
+- '824.9'
+- '825.9'
+- "[6] High Availability Concerns"
+--- 
+- '985.1'
+- '986.1'
+- "[7] User Selectable Durability"
+--- 
+- '1215.3'
+- '1216.3'
+- "[8] Latency and Sync Performance"
+--- 
+- '1259.3'
+- '1260.3'
+- "[9] Hard Drive Latency"
+--- 
+- '1485.7'
+- '1486.7'
+- "[10] Latency impact on throughput"
+--- 
+- '1839.3'
+- '1840.3'
+- "[11] Five durability levels"
+--- 
+- '2034.7'
+- '2035.7'
+- "[12] Synchronous Performance"
+--- 
+- '2167.6'
+- '2168.6'
+- "[13] Light is pretty fast, right?"
+--- 
+- '2200.5'
+- '2201.5'
+- "[14] Observed latency"
+--- 
+- '2300.2'
+- '2301.2'
+- "[15] Measured Network Latency"
+--- 
+- '2544.2'
+- '2545.2'
+- "[16] Scaling test"
+--- 
+- '2670.6'
+- '2671.6'
+- "[17] Group commit magic"
+--- 
+- '2734.3'
+- '2735.3'
+- "[18] Conclusions"
+--- 
+- '2845.4'
+- '2846.4'
+- "[19] Questions?"

diff --git a/media/PgConfEu2011-sync_replication/www.sh b/media/PgConfEu2011-sync_replication/www.sh
new file mode 100755 (executable)
index 0000000..b89125f
--- /dev/null
+++ b/media/PgConfEu2011-sync_replication/www.sh
@@ -0,0 +1,2 @@
+wget -nc http://www.2ndquadrant.com/static/2quad/media/pdfs/talks/SyncRepDurability.pdf
+clive --format=best http://www.youtube.com/watch?v=XL7j8hTd6R8