Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitc441e26

Browse files
committed
Done:
< * Allow buffered WAL writes and fsync
1 parent4a78cde commitc441e26

File tree

2 files changed

+4
-19
lines changed

2 files changed

+4
-19
lines changed

‎doc/TODO‎

Lines changed: 2 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
PostgreSQL TODO List
22
====================
33
Current maintainer:Bruce Momjian (bruce@momjian.us)
4-
Last updated:Tue Jul 17 20:15:52 EDT 2007
4+
Last updated:Wed Aug 1 19:13:20 EDT 2007
55

66
The most recent version of this document can be viewed at
77
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -1330,15 +1330,7 @@ Write-Ahead Log
13301330
rotation to fsync again. One idea is to write the WAL to different
13311331
offsets that might reduce the rotational delay.
13321332

1333-
* Allow buffered WAL writes and fsync
1334-
1335-
Instead of guaranteeing recovery of all committed transactions, this
1336-
would provide improved performance by delaying WAL writes and fsync
1337-
so an abrupt operating system restart might lose a few seconds of
1338-
committed transactions but still be consistent. We could perhaps
1339-
remove the 'fsync' parameter (which results in an an inconsistent
1340-
database) in favor of this capability.
1341-
1333+
* -Allow buffered WAL writes and fsync
13421334
* Allow WAL logging to be turned off for a table, but the table
13431335
might be dropped or truncated during crash recovery [walcontrol]
13441336

‎doc/src/FAQ/TODO.html‎

Lines changed: 2 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">
99
<h1><aname="section_1">PostgreSQL TODO List</a></h1>
1010
<p>Current maintainer: Bruce Momjian (<ahref="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/>
11-
Last updated:Tue Jul 17 20:15:52 EDT 2007
11+
Last updated:Wed Aug 1 19:13:20 EDT 2007
1212
</p>
1313
<p>The most recent version of this document can be viewed at<br/>
1414
<ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
@@ -1182,14 +1182,7 @@ <h1><a name="section_18">Write-Ahead Log</a></h1>
11821182
rotation to fsync again. One idea is to write the WAL to different
11831183
offsets that might reduce the rotational delay.
11841184
</p>
1185-
</li><li>Allow buffered WAL writes and fsync
1186-
<p> Instead of guaranteeing recovery of all committed transactions, this
1187-
would provide improved performance by delaying WAL writes and fsync
1188-
so an abrupt operating system restart might lose a few seconds of
1189-
committed transactions but still be consistent. We could perhaps
1190-
remove the 'fsync' parameter (which results in an an inconsistent
1191-
database) in favor of this capability.
1192-
</p>
1185+
</li><li>-<em>Allow buffered WAL writes and fsync</em>
11931186
</li><li>Allow WAL logging to be turned off for a table, but the table
11941187
might be dropped or truncated during crash recovery [<ahref="http://momjian.postgresql.org/cgi-bin/pgtodo?walcontrol">walcontrol</a>]
11951188
<p> Allow tables to bypass WAL writes and just fsync() dirty pages on

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp