From 85df43f341843af272f307449c7647df566e1c55 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 30 May 2007 19:07:20 +0000 Subject: [PATCH] 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. --- doc/TODO | 5 ++-- doc/src/FAQ/TODO.html | 60 +++++++++++++++++++++---------------------- 2 files changed, 31 insertions(+), 34 deletions(-) diff --git a/doc/TODO b/doc/TODO index 0de1ce3a40..162eb3c0ba 100644 --- a/doc/TODO +++ b/doc/TODO @@ -1,8 +1,7 @@ -z PostgreSQL TODO List ==================== Current maintainer: Bruce Momjian (bruce@momjian.us) -Last updated: Mon May 28 19:56:23 EDT 2007 +Last updated: Wed May 30 15:07:10 EDT 2007 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -1169,8 +1168,8 @@ Vacuum 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-03/msg00024.php + http://archives.postgresql.org/pgsql-performance/2007-05/msg00296.php * Reduce lock time during VACUUM FULL by moving tuples with read lock, then write lock and truncate table diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index 2cf33ace80..244ebbaf86 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -2,16 +2,14 @@ "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> -z +PostgreSQL TODO List -

z
-PostgreSQL TODO List -

-Current maintainer: Bruce Momjian (bruce@momjian.us)
-Last updated: Mon May 28 19:56:23 EDT 2007 - +

PostgreSQL TODO List

Current maintainer: Bruce Momjian (bruce@momjian.us)
+Last updated: Wed May 30 15:07:10 EDT 2007 +

The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html.

@@ -25,7 +23,7 @@ you would like to work on an item, please read the Developer's FAQ
first. There is also a developer's wiki at
http://developer.postgresql.org.

Administration

Allow major upgrades without dump/reload, perhaps using pg_upgrade @@ -158,7 +156,7 @@ first. There is also a developer's wiki at

Monitoring

Allow server log information to be output as INSERT statements @@ -167,7 +165,7 @@ first. There is also a developer's wiki at
-Add ability to monitor the use of temporary sort files

Data Types

-Make 64-bit version of the MONEY data type @@ -309,7 +307,7 @@ first. There is also a developer's wiki at

Functions

Allow INET subnet tests using non-constants to be indexed @@ -365,7 +363,7 @@ first. There is also a developer's wiki at
e.g. box @> point

Multi-Language Support

Add NCHAR (as distinguished from ordinary varchar), @@ -406,7 +404,7 @@ first. There is also a developer's wiki at

http://archives.postgresql.org/pgsql-hackers/2007-03/msg00767.php

Views / Rules

Automatically create rules on views so they are updateable, per SQL99 @@ -423,7 +421,7 @@ first. There is also a developer's wiki at
are added after the view is created.

SQL Commands

Add CORRESPONDING BY to UNION/INTERSECT/EXCEPT @@ -720,7 +718,7 @@ first. There is also a developer's wiki at

Clients

Have pg_ctl look at PGHOST in case it is a socket directory? @@ -834,7 +832,7 @@ first. There is also a developer's wiki at

Triggers

Add deferred trigger queue file @@ -869,7 +867,7 @@ first. There is also a developer's wiki at

http://archives.postgresql.org/pgsql-general/2007-02/msg01466.php

Dependency Checking

-Flush cached query plans when the dependent objects change or @@ -878,7 +876,7 @@ first. There is also a developer's wiki at
-Invalidate prepared queries, like INSERT, when the table definition is altered

Indexes

Add UNIQUE capability to non-btree indexes @@ -951,7 +949,7 @@ first. There is also a developer's wiki at

Fsync

Improve commit_delay handling to reduce fsync() @@ -969,7 +967,7 @@ first. There is also a developer's wiki at
http://archives.postgresql.org/pgsql-hackers/2007-01/msg00079.php

Cache Usage

Allow free-behind capability for large sequential scans, perhaps using @@ -1034,15 +1032,15 @@ first. There is also a developer's wiki at
http://archives.postgresql.org/pgsql-hackers/2007-01/msg00752.php

Vacuum

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-03/msg00024.php + http://archives.postgresql.org/pgsql-hackers/2007-03/msg00024.php + http://archives.postgresql.org/pgsql-performance/2007-05/msg00296.php
Reduce lock time during VACUUM FULL by moving tuples with read lock, then write lock and truncate table @@ -1104,7 +1102,7 @@ first. There is also a developer's wiki at

Locking

Fix priority ordering of read and write light-weight locks (Neil) @@ -1124,7 +1122,7 @@ first. There is also a developer's wiki at
Add idle_in_transaction_timeout GUC so locks are not held for long periods of time

Startup Time Improvements

Experiment with multi-threaded backend for backend creation [thread] @@ -1147,7 +1145,7 @@ first. There is also a developer's wiki at
existing backends is one of the difficulties with a backend approach.

Write-Ahead Log

Eliminate need to write full pages to WAL before page modification [wal] @@ -1213,7 +1211,7 @@ first. There is also a developer's wiki at
of indexes on TOAST tables.

Optimizer / Executor

Improve selectivity functions for geometric operators @@ -1238,7 +1236,7 @@ first. There is also a developer's wiki at

http://archives.postgresql.org/pgsql-hackers/2007-01/msg00096.php

Miscellaneous Performance

Do async I/O for faster random read-ahead of data @@ -1283,7 +1281,7 @@ first. There is also a developer's wiki at

http://archives.postgresql.org/pgsql-hackers/2007-01/msg00752.php

Source Code

Add use of 'const' for variables in source tree @@ -1368,7 +1366,7 @@ first. There is also a developer's wiki at
of result sets using new statement protocol

Exotic Features

Add pre-parsing phase that converts non-ISO syntax to supported @@ -1396,7 +1394,7 @@ first. There is also a developer's wiki at
http://archives.postgresql.org/pgsql-hackers/2006-10/msg01527.php

Features We Do Not Want

All backends running as threads in a single process (not wanted) -- 2.40.0