|
1 | 1 | TODO list for PostgreSQL
|
2 | 2 | ========================
|
3 |
| -Last updated:Sat Jun1 15:52:53 EDT 2002 |
| 3 | +Last updated:Mon Jun3 13:40:49 EDT 2002 |
4 | 4 |
|
5 | 5 | Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)
|
6 | 6 |
|
@@ -148,7 +148,8 @@ Indexes
|
148 | 148 | * Add UNIQUE capability to non-btree indexes
|
149 | 149 | * Add btree index support for reltime, tinterval, regproc
|
150 | 150 | * Add rtree index support for line, lseg, path, point
|
151 |
| -* Certain indexes will not shrink, e.g. oid indexes with many inserts |
| 151 | +* Certain indexes will not shrink, e.g. indexes on ever-increasing |
| 152 | + columns and indexes with many duplicate keys |
152 | 153 | * Use indexes for min() and max() or convert to SELECT col FROM tab ORDER
|
153 | 154 | BY col DESC LIMIT 1 if appropriate index exists and WHERE clause acceptible
|
154 | 155 | * Allow LIKE indexing optimization for non-ASCII locales
|
|