|
1 | 1 | TODO list for PostgreSQL |
2 | 2 | ======================== |
3 | | -Last updated:Tue Sep4 12:27:12 EDT 2001 |
| 3 | +Last updated:Wed Sep5 20:04:07 EDT 2001 |
4 | 4 |
|
5 | 5 | Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us) |
6 | 6 |
|
@@ -178,7 +178,8 @@ COMMANDS |
178 | 178 | o Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..) |
179 | 179 | o Allow INSERT INTO my_table VALUES (a, b, c, DEFAULT, x, y, z, ...) |
180 | 180 | o Disallow missing columns in INSERT ... VALUES, per ANSI |
181 | | -o Allow INSERT/UPDATE ... RETURNING new.col or old.col (Philip) |
| 181 | +o Allow INSERT/UPDATE ... RETURNING new.col or old.col, handle |
| 182 | + RULE cases (Philip) |
182 | 183 | * SHOW/SET |
183 | 184 | o Add SHOW command to display locks |
184 | 185 | o -Add SHOW command to show all settings |
@@ -310,8 +311,11 @@ MISCELLANEOUS |
310 | 311 | * Allow logging of query durations |
311 | 312 | * Add hash for evaluating GROUP BY aggregates |
312 | 313 | * -Read pg_hba.conf only on postmaster startup or SIGHUP (Bruce) |
313 | | -* Improve spinlock code, perhaps with OS semaphores, sleeper queue, or |
314 | | - spining to obtain lock on multi-cpu systems |
| 314 | +* Improve spinlock code |
| 315 | +o use SysV semaphores or queue of backends waiting on the lock |
| 316 | +o wakeup sleeper or sleep for less than one clock tick |
| 317 | +o spin for lock on multi-cpu machines, yield on single cpu machines |
| 318 | +o read/write locks |
315 | 319 | * Add queue of backends waiting for spinlock |
316 | 320 |
|
317 | 321 | SOURCE CODE |
|