11TODO list for PostgreSQL
22========================
3- Last updated:Tue Apr23 16:26:13 EDT 2002
3+ Last updated:Thu Apr25 16:20:14 EDT 2002
44
55Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)
66
@@ -12,8 +12,8 @@ A dash (-) marks changes that will appear in the upcoming 7.3 release.
1212Bracketed items "[]" have more detailed.
1313
1414
15- URGENT
16- ------
15+ Urgent
16+ ======
1717
1818* Add replication of distributed databases [replication]
1919o automatic failover
2828* Point-in-time data recovery using backup and write-ahead log
2929
3030
31- REPORTING
32- ---------
31+ Reporting
32+ =========
3333
3434* Allow elog() to return error codes, module name, file name, line
3535 number, not just messages (Peter E)
@@ -38,8 +38,8 @@ REPORTING
3838* Show location of syntax error in query [yacc]
3939
4040
41- PERMISSIONS
42- -----------
41+ Permissions
42+ ===========
4343
4444* Improve control over user privileges, including table creation and
4545 lock use [privileges] (Karel, others)
@@ -52,8 +52,8 @@ PERMISSIONS
5252* -Allow permissions for functions (Peter E)
5353
5454
55- ADMIN
56- -----
55+ Administration
56+ ==============
5757
5858* Incremental backups
5959* -Make it easier to create a database owned by someone who can't createdb,
6969 specified parameters to postgresql.conf defaults (Peter E)
7070* Allow easy display of usernames in a group
7171
72- DATA TYPES
73- ----------
72+ Data Types
73+ ==========
7474
7575* -Add domain capability (Rod Taylor)
7676* Add IPv6 capability to INET/CIDR types
@@ -104,8 +104,8 @@ DATA TYPES
104104o Auto-delete large objects when referencing row is deleted
105105
106106
107- MULTI-LANGUAGE SUPPORT
108- ----------------------
107+ Multi-Language Support
108+ ======================
109109
110110* Add NCHAR (as distinguished from ordinary varchar),
111111* Allow LOCALE on a per-column basis, default to ASCII
@@ -117,8 +117,8 @@ MULTI-LANGUAGE SUPPORT
117117* Make octet_length_client the same as octet_length() (?)
118118
119119
120- VIEWS /RULES
121- -------------
120+ Views /Rules
121+ =============
122122
123123* Automatically create rules on views so they are updateable, per SQL92 [view]
124124* Add the functionality for WITH CHECK OPTION clause of CREATE VIEW
@@ -131,8 +131,8 @@ VIEWS / RULES
131131* Prevent aggregates from being used in rule WHERE clauses
132132
133133
134- INDEXES
135- -------
134+ Indexes
135+ =======
136136
137137* Allow CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops)
138138 fails index can't store constant parameters
@@ -166,8 +166,8 @@ INDEXES
166166* Test hash index performance and recommend or discourage usage
167167
168168
169- COMMANDS
170- --------
169+ Commands
170+ ========
171171
172172* Add SIMILAR TO to allow character classes, 'pg_[a-c]%'
173173* Add BETWEEN ASYMMETRIC/SYMMETRIC (Christopher)
@@ -251,8 +251,8 @@ COMMANDS
251251 o Fix PL/pgSQL RENAME to work on variables other than OLD/NEW
252252
253253
254- CLIENTS
255- -------
254+ Clients
255+ =======
256256
257257* Have pg_dump use LEFT OUTER JOIN in multi-table SELECTs
258258 or multiple SELECTS to avoid bad system catalog entries
@@ -296,8 +296,8 @@ CLIENTS
296296o Updatable cursors support
297297
298298
299- REFERENTIAL INTEGRITY
300- ---------------------
299+ Referential Integrity
300+ =====================
301301
302302* Add MATCH PARTIAL referential integrity [foreign]
303303* Add deferred trigger queue file (Jan)
@@ -312,8 +312,8 @@ REFERENTIAL INTEGRITY
312312* Fix foreign key constraints to not error on intermediate db states (Stephan)
313313
314314
315- DEPENDENCY CHECKING
316- -------------------
315+ Dependency Checking
316+ ===================
317317
318318* Add pg_depend table for dependency recording; use sysrelid, oid,
319319 depend_sysrelid, depend_oid, name
@@ -329,16 +329,16 @@ DEPENDENCY CHECKING
329329* Flush cached query plans when their underlying catalog data changes
330330
331331
332- TRANSACTIONS
333- ------------
332+ Transactions
333+ ============
334334
335335* Allow autocommit so always in a transaction block
336336* Overhaul bufmgr/lockmgr/transaction manager
337337* Allow savepoints / nested transactions [transactions]
338338
339339
340- EXOTIC FEATURES
341- ---------------
340+ Exotic Features
341+ ===============
342342
343343* Add sql3 recursive unions
344344* Add the concept of dataspaces/tablespaces [tablespaces]
@@ -354,17 +354,17 @@ PERFORMANCE
354354===========
355355
356356
357- FSYNC
358- -----
357+ Fsync
358+ =====
359359
360360* Delay fsync() when other backends are about to commit too [fsync]
361361o Determine optimal commit_delay value
362362* Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options
363363o Allow multiple blocks to be written to WAL with one write()
364364
365365
366- CACHE
367- -----
366+ Cache
367+ =====
368368* Cache most recent query plan(s) (Neil) [prepare]
369369* Shared catalog cache, reduce lseek()'s by caching table size in shared area
370370* Add free-behind capability for large sequential scans (Bruce)
@@ -373,17 +373,17 @@ CACHE
373373* Make blind writes go through the file descriptor cache
374374
375375
376- VACUUM
377- ------
376+ Vacuum
377+ ======
378378
379379* Improve speed with indexes (perhaps recreate index instead) [vacuum]
380380* Reduce lock time by moving tuples with read lock, then write
381381 lock and truncate table [vacuum]
382382* Provide automatic running of vacuum in the background (Tom)
383383
384384
385- LOCKING
386- -------
385+ Locking
386+ =======
387387
388388* Make locking of shared data structures more fine-grained
389389* Add code to detect an SMP machine and handle spinlocks accordingly
@@ -392,8 +392,8 @@ LOCKING
392392* Research use of sched_yield() for spinlock acquisition failure
393393
394394
395- STARTUP TIME
396- ------------
395+ Startup Time
396+ ============
397397
398398* Experiment with multi-threaded backend [thread]
399399* Add connection pooling [pool]
@@ -406,8 +406,8 @@ STARTUP TIME
406406* -Cache system catalog information in per-database files (Tom)
407407
408408
409- WRITE-AHEAD LOG
410- ---------------
409+ Write-Ahead Log
410+ ===============
411411
412412* Have after-change WAL write()'s write only modified data to kernel
413413* Reduce number of after-change WAL writes; they exist only to gaurd against
@@ -421,8 +421,8 @@ WRITE-AHEAD LOG
421421 that are too frequent
422422
423423
424- OPTIMIZER /EXECUTOR
425- --------------------
424+ Optimizer /Executor
425+ ====================
426426
427427* Improve Subplan list handling
428428* Allow Subplans to use efficient joins(hash, merge) with upper variable
@@ -443,8 +443,8 @@ OPTIMIZER / EXECUTOR
443443* Add utility to compute accurate random_page_cost value
444444* Improve ability to display optimizer analysis using OPTIMIZER_DEBUG
445445
446- MISCELLANEOUS
447- -------------
446+ Miscellaneous
447+ =============
448448
449449* Do async I/O for faster random read-ahead of data
450450* Get faster regex() code from Henry Spencer <henry@zoo.utoronto.ca>
@@ -456,7 +456,7 @@ MISCELLANEOUS
456456* -Use faster flex flags for performance improvement (Peter E)
457457* Add BSD-licensed qsort() for Solaris
458458
459- SOURCE CODE
459+ Source Code
460460===========
461461
462462* Add use of 'const' for variables in source tree