|
1 | 1 | TODO list for PostgreSQL |
2 | 2 | ======================== |
3 | | -Last updated:Tue Jan 9 13:05:49 EST 2001 |
| 3 | +Last updated:Thu Jan11 16:06:57 EST 2001 |
4 | 4 |
|
5 | 5 | Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us) |
6 | 6 |
|
@@ -151,8 +151,12 @@ COMMANDS |
151 | 151 | * Add ALTER TABLE ... DROP CONSTRAINT |
152 | 152 | * -Add ALTER USER command to change user db attributes (Peter E) |
153 | 153 | * Automatically drop constraints/functions when object is dropped |
154 | | -* Allow CLUSTER on all tables at once, and improve CLUSTER, loses NOT |
155 | | -NULL specification, indexes, permissions, etc on table |
| 154 | +* CLUSTER |
| 155 | +* cluster all tables at once |
| 156 | +* prent lose of constraints, indexes, permissions, inheritance |
| 157 | +* Automatically keep clustering on a table |
| 158 | +* Keep statistics about clustering, perhaps during VACUUM ANALYZE |
| 159 | + [optimizer] |
156 | 160 | * Add SIMILAR TO to allow character classes, 'pg_[a-c]%' |
157 | 161 | * Auto-destroy sequence on DROP of table with SERIAL (Ryan) |
158 | 162 | * Allow LOCK TABLE tab1, tab2, tab3 so all tables locked in unison [lock] |
|
284 | 288 | * -Redesign ANALYZE in VACUUM so it can be run separately without locks |
285 | 289 | * Make ANALYZE a separate command |
286 | 290 | * Gather more accurate dispersion statistics using indexes |
287 | | -* Keep statistics about clustering of table rows [optimizer] |
288 | | -* Automatically keep clustering on a table |
289 | 291 | * Improve statistics storage in pg_class [performance] |
290 | 292 | * Improve VACUUM speed with indexes [vacuum] |
291 | 293 | * Reduce VACUUM lock time by moving tuples with read lock, then write |
|