Commit487990e

committed

Add description:

>> O_DIRECT doesn't have the same media write guarantees as fsync, so it> is in addition to the fsync method, not in place of it.>

1 parent1bc9235 commit487990eCopy full SHA for 487990e

File tree

-2

lines changed

-2

lines changed

Lines changed: 5 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -2,7 +2,7 @@`
`2`	`2`	`PostgreSQL TODO List`
`3`	`3`	`====================`
`4`	`4`	`Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)`
`5`		`-Last updated:Fri Jun3 17:42:10 EDT 2005`
	`5`	`+Last updated:Sat Jun4 12:53:41 EDT 2005`
`6`	`6`
`7`	`7`	`The most recent version of this document can be viewed at`
`8`	`8`	`http://www.postgresql.org/docs/faqs.TODO.html.`
`@@ -722,6 +722,10 @@ Cache`
`722`	`722`
`723`	`723`	`* Consider use of open/fcntl(O_DIRECT) to minimize OS caching,`
`724`	`724`	`especially for WAL writes`
	`725`	`+`
	`726`	`+ O_DIRECT doesn't have the same media write guarantees as fsync, so it`
	`727`	`+ is in addition to the fsync method, not in place of it.`
	`728`	`+`
`725`	`729`	`* -Cache last known per-tuple offsets to speed long tuple access`
`726`	`730`	`* Speed up COUNT(*)`
`727`	`731`

Lines changed: 4 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">`
`9`	`9`	`<h1><aname="section_1">PostgreSQL TODO List</a></h1>`
`10`	`10`	`<p>Current maintainer: Bruce Momjian (<ahref="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/>`
`11`		`-Last updated:Fri Jun3 17:42:10 EDT 2005`
	`11`	`+Last updated:Sat Jun4 12:53:41 EDT 2005`
`12`	`12`	`</p>`
`13`	`13`	`<p>The most recent version of this document can be viewed at<br/>`
`14`	`14`	`<ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.`
`@@ -663,6 +663,9 @@ <h1><a name="section_13">Cache</a></h1>`
`663`	`663`	`</p>`
`664`	`664`	`</li><li>Consider use of open/fcntl(O_DIRECT) to minimize OS caching,`
`665`	`665`	`especially for WAL writes`
	`666`	`+<p> O_DIRECT doesn't have the same media write guarantees as fsync, so it`
	`667`	`+ is in addition to the fsync method, not in place of it.`
	`668`	`+</p>`
`666`	`669`	`</li><li>-<em>Cache last known per-tuple offsets to speed long tuple access</em>`
`667`	`670`	`</li><li>Speed up COUNT(*)`
`668`	`671`	`<p> We could use a fixed row count and a +/- count to follow MVCC`

Comments

(0)