|
1 | 1 | TODO list for PostgreSQL |
2 | 2 | ======================== |
3 | | -Last updated:Mon Sep 29 17:41:25 EDT 2003 |
| 3 | +Last updated:Sat Oct 4 14:19:54 EDT 2003 |
4 | 4 |
|
5 | 5 | Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us) |
6 | 6 |
|
@@ -388,7 +388,8 @@ Cache |
388 | 388 | * Make blind writes go through the file descriptor cache |
389 | 389 | * Cache last known per-tuple offsets to speed long tuple access |
390 | 390 | * Automatically place fixed-width, NOT NULL columns first in a table |
391 | | -* Consider using MVCC to cache count(*) queries with no WHERE clause |
| 391 | +* Use a fixed row count and a +/- count with MVCC visibility rules |
| 392 | + to allow fast COUNT(*) queries with no WHERE clause(?) |
392 | 393 |
|
393 | 394 |
|
394 | 395 | Vacuum |
@@ -501,7 +502,7 @@ Source Code |
501 | 502 | * Acquire lock on a relation before building a relcache entry for it |
502 | 503 | * Research interaction of setitimer() and sleep() used by statement_timeout |
503 | 504 | * Add checks for fclose() failure |
504 | | -* Change CVS $Id: TODO,v 1.1141 2003/09/29 21:41:29 momjian Exp $ to $PostgreSQL: pgsql/doc/TODO,v 1.1141 2003/09/29 21:41:29 momjian Exp $ |
| 505 | +* Change CVS $Id: TODO,v 1.1142 2003/10/04 18:19:57 momjian Exp $ to $PostgreSQL: pgsql/doc/TODO,v 1.1142 2003/10/04 18:19:57 momjian Exp $ |
505 | 506 | * Exit postmaster if postgresql.conf can not be opened |
506 | 507 | * Rename /scripts directory because they are all C programs now |
507 | 508 | * Allow the regression tests to start postmaster with -i so the tests |
|