|
1 | 1 | TODO list for PostgreSQL |
2 | 2 | ======================== |
3 | | -Last updated:Tue Jan 22 15:39:51 EST 2002 |
| 3 | +Last updated:Tue Jan 22 15:49:54 EST 2002 |
4 | 4 |
|
5 | 5 | Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us) |
6 | 6 |
|
@@ -372,44 +372,57 @@ VACUUM |
372 | 372 | * -Allow ANALYZE to ESTIMATE based on certain random precentage of rows (Tom) |
373 | 373 | * Add LAZY VACUUM (Vadim) [performance] |
374 | 374 |
|
375 | | -MISCELLANEOUS |
| 375 | +LOCKING |
| 376 | + |
| 377 | +* Make locking of shared data structures more fine-grained |
| 378 | +* Add code to detect an SMP machine and handle spinlocks accordingly |
| 379 | +* Research use of sched_yield() for spinlock acquisition failure |
| 380 | +* -Improve spinlock code [performance] (Tom) |
| 381 | + |
| 382 | +STARTUP TIME |
376 | 383 |
|
377 | | -* -Allow compression of log and meta data (Tom) |
378 | | -* Do async I/O for faster random read-ahead of data |
379 | 384 | * Experiment with multi-threaded backend [thread] |
380 | | -* Get faster regex() code from Henry Spencer <henry@zoo.utoronto.ca> |
381 | | - when it is available |
382 | | -* Use mmap() rather than SYSV shared memory(?) [mmap] |
383 | | -* Use mmap() to write WAL files (?) [mmap] |
384 | | -* Improve Subplan list handling |
385 | | -* Allow Subplans to use efficient joins(hash, merge) with upper variable |
386 | | -* Improve dynamic memory allocation by introducing tuple-context memory |
387 | | - allocation (Tom) |
388 | | -* -Allow GUC configuration of maximum number of open files (Tom) |
389 | | -* -Improve statistics storage in pg_class [performance] (Tom) |
390 | 385 | * Add connection pooling [pool] |
391 | 386 | * Allow persistent backends [persistent] |
392 | 387 | * Create a transaction processor to aid in persistent connections and |
393 | 388 | connection pooling |
394 | | -* Allow logging of query durations |
395 | | -* Add hash for evaluating GROUP BY aggregates |
396 | | -* -Read pg_hba.conf only on postmaster startup or SIGHUP (Bruce) |
| 389 | +* Do listen() in postmaster and accept() in pre-forked backend |
| 390 | +* Have pre-forked backend pre-connect to last requested database or pass |
| 391 | + file descriptor to backend pre-forked for matching database |
| 392 | + |
| 393 | +WRITE-AHEAD LOG |
| 394 | + |
397 | 395 | * Have after-change WAL write()'s write only modified data to kernel |
398 | 396 | * Reduce number of after-change WAL writes; they exist only to gaurd against |
399 | 397 | partial page writes |
400 | 398 | * Turn off after-change writes if fsync is disabled (?) |
401 | | -* -Improve spinlock code [performance] (Tom) |
402 | | -* Do listen() in postmaster and accept() in pre-forked backend |
403 | | -* Have pre-forked backend pre-connect to last requested database or pass |
404 | | - file descriptor to backend pre-forked for matching database |
| 399 | + |
| 400 | +OPTIMIZER/EXECUTOR |
| 401 | + |
| 402 | +* Improve Subplan list handling |
| 403 | +* Allow Subplans to use efficient joins(hash, merge) with upper variable |
| 404 | +* Improve dynamic memory allocation by introducing tuple-context memory |
| 405 | + allocation (Tom) |
| 406 | +* Add hash for evaluating GROUP BY aggregates |
405 | 407 | * Nested FULL OUTER JOINs don't work (Tom) |
406 | 408 | * Allow merge and hash joins on expressions not just simple variables (Tom) |
407 | 409 | * Add new pg_proc cachable settings to specify whether function can be |
408 | 410 | evaluated only once or once per query |
409 | 411 | * Change FIXED_CHAR_SEL to 0.20 from 0.04 to give better selectivity (Bruce) |
410 | | -* Make locking of shared data structures more fine-grained |
411 | 412 | * Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS [exists] |
412 | | -* Add code to detect an SMP machine and handle spinlocks accordingly |
| 413 | + |
| 414 | +MISCELLANEOUS |
| 415 | + |
| 416 | +* -Allow compression of log and meta data (Tom) |
| 417 | +* Do async I/O for faster random read-ahead of data |
| 418 | +* Get faster regex() code from Henry Spencer <henry@zoo.utoronto.ca> |
| 419 | + when it is available |
| 420 | +* Use mmap() rather than SYSV shared memory or to write WAL files (?) [mmap] |
| 421 | +* -Allow GUC configuration of maximum number of open files (Tom) |
| 422 | +* -Improve statistics storage in pg_class [performance] (Tom) |
| 423 | +* Allow logging of query durations |
| 424 | +* -Read pg_hba.conf only on postmaster startup or SIGHUP (Bruce) |
| 425 | + |
413 | 426 |
|
414 | 427 | SOURCE CODE |
415 | 428 | ----------- |
|