Commit3030f18

committed

Add URL for:

* Improve speed with indexes For large table adjustments during VACUUM FULL, it is faster to cluster or reindex rather than update the index. Also, index updates can bloat the index.>http://archives.postgresql.org/pgsql-hackers/2007-08/msg00307.php

1 parentab2ff36 commit3030f18Copy full SHA for 3030f18

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,7 +1,7 @@`
`1`	`1`	`PostgreSQL TODO List`
`2`	`2`	`====================`
`3`	`3`	`Current maintainer:Bruce Momjian (bruce@momjian.us)`
`4`		`-Last updated:Tue Mar 11 21:40:05 EDT 2008`
	`4`	`+Last updated:Tue Mar 11 21:47:58 EDT 2008`
`5`	`5`
`6`	`6`	`The most recent version of this document can be viewed at`
`7`	`7`	`http://www.postgresql.org/docs/faqs.TODO.html.`
`@@ -1283,6 +1283,7 @@ Vacuum`
`1283`	`1283`
`1284`	`1284`	`http://archives.postgresql.org/pgsql-hackers/2007-03/msg00024.php`
`1285`	`1285`	`http://archives.postgresql.org/pgsql-performance/2007-05/msg00296.php`
	`1286`	`+ http://archives.postgresql.org/pgsql-hackers/2007-08/msg00307.php`
`1286`	`1287`
`1287`	`1288`	`* Auto-fill the free space map by scanning the buffer cache or by`
`1288`	`1289`	`checking pages written by the background writer`

Lines changed: 2 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:bruce@momjian.us">bruce@momjian.us</a>)<br/>`
`11`		`-Last updated: Tue Mar 11 21:40:05 EDT 2008`
	`11`	`+Last updated: Tue Mar 11 21:47:58 EDT 2008`
`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>.`
`@@ -1121,6 +1121,7 @@ <h1><a name="section_15">Vacuum</a></h1>`
`1121`	`1121`	`</p>`
`1122`	`1122`	`<p><ahref="http://archives.postgresql.org/pgsql-hackers/2007-03/msg00024.php">http://archives.postgresql.org/pgsql-hackers/2007-03/msg00024.php</a>`
`1123`	`1123`	`<ahref="http://archives.postgresql.org/pgsql-performance/2007-05/msg00296.php">http://archives.postgresql.org/pgsql-performance/2007-05/msg00296.php</a>`
	`1124`	`+<ahref="http://archives.postgresql.org/pgsql-hackers/2007-08/msg00307.php">http://archives.postgresql.org/pgsql-hackers/2007-08/msg00307.php</a>`
`1124`	`1125`	`</p>`
`1125`	`1126`	`</li><li>Auto-fill the free space map by scanning the buffer cache or by`
`1126`	`1127`	`checking pages written by the background writer`

Comments

(0)