diff options
| author | Bruce Momjian | 2007-04-02 22:49:03 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2007-04-02 22:49:03 +0000 |
| commit | 17285959c1698d8853311a77fbae2a5c582df0b1 (patch) | |
| tree | 81b5c1361a3133f00fdab05cc4830608862d5352 /doc/TODO | |
| parent | 3a7d66b48a101e7ac4b85c332b2b87d24ecb6d84 (diff) | |
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-03/msg00024.php
Diffstat (limited to 'doc/TODO')
| -rw-r--r-- | doc/TODO | 10 |
1 files changed, 6 insertions, 4 deletions
@@ -2,7 +2,7 @@ PostgreSQL TODO List ==================== Current maintainer: Bruce Momjian (bruce@momjian.us) -Last updated: Mon Apr 2 18:46:07 EDT 2007 +Last updated: Mon Apr 2 18:48:47 EDT 2007 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -1169,9 +1169,11 @@ Vacuum * Improve speed with indexes - For large table adjustments during VACUUM FULL, it is faster to - reindex rather than update the index. Also, index updates can - bloat the index. + 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 * Reduce lock time during VACUUM FULL by moving tuples with read lock, then write lock and truncate table |