From 0e0793a71a76e9d2ba4033f942a1f01409383312 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 14 Aug 2004 01:30:49 +0000 Subject: [PATCH] Add: > > * Allow buffered WAL writes and fsync > > Instead of guaranteeing recovery of all committed transactions, this > would provide improved performance by delaying WAL writes and fsync > so an abrupt operating system restart might lose a few seconds of > committed transactions but still be consistent. We could perhaps > remove the 'fsync' parameter (which results in an an inconsistent > database) in favor of this capability. --- doc/TODO | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) diff --git a/doc/TODO b/doc/TODO index 508d26db5f..2c1534cc98 100644 --- a/doc/TODO +++ b/doc/TODO @@ -5,7 +5,7 @@ TODO list for PostgreSQL Bracketed items "[]" have more detail. Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) -Last updated: Thu Aug 12 22:47:54 EDT 2004 +Last updated: Fri Aug 13 21:30:49 EDT 2004 The most recent version of this document can be viewed at the PostgreSQL web site, http://www.PostgreSQL.org. @@ -715,6 +715,15 @@ Write-Ahead Log rotation to fsync again. One idea is to write the WAL to different offsets that might reduce the rotational delay. +* Allow buffered WAL writes and fsync + + Instead of guaranteeing recovery of all committed transactions, this + would provide improved performance by delaying WAL writes and fsync + so an abrupt operating system restart might lose a few seconds of + committed transactions but still be consistent. We could perhaps + remove the 'fsync' parameter (which results in an an inconsistent + database) in favor of this capability. + Optimizer / Executor ==================== -- 2.40.0