diff options
| author | Bruce Momjian <bruce@momjian.us> | 2003-10-10 01:52:15 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2003-10-10 01:52:15 +0000 |
| commit | 20982a71dffadd960379c607452bd7a89fdb7a80 (patch) | |
| tree | 45de10d87263cda745fb80d88408e50cf7c1c4fa | |
| parent | 99a53d89c80ccfe752884765b6471bc787a0a00f (diff) | |
Add TODO.detail for count(*):
> to allow fast COUNT(*) queries with no WHERE clause(?) [count]
| -rw-r--r-- | doc/TODO | 6 |
1 files changed, 3 insertions, 3 deletions
@@ -1,6 +1,6 @@ TODO list for PostgreSQL ======================== -Last updated: Thu Oct 9 19:41:24 EDT 2003 +Last updated: Thu Oct 9 21:52:10 EDT 2003 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -393,7 +393,7 @@ Cache * Cache last known per-tuple offsets to speed long tuple access * Automatically place fixed-width, NOT NULL columns first in a table * Use a fixed row count and a +/- count with MVCC visibility rules - to allow fast COUNT(*) queries with no WHERE clause(?) + to allow fast COUNT(*) queries with no WHERE clause(?) [count] Vacuum @@ -508,7 +508,7 @@ Source Code * Acquire lock on a relation before building a relcache entry for it * Research interaction of setitimer() and sleep() used by statement_timeout * Add checks for fclose() failure -* Change CVS $Id: TODO,v 1.1149 2003/10/09 23:41:22 momjian Exp $ to $PostgreSQL: pgsql/doc/TODO,v 1.1149 2003/10/09 23:41:22 momjian Exp $ +* Change CVS $Id: TODO,v 1.1150 2003/10/10 01:52:15 momjian Exp $ to $PostgreSQL: pgsql/doc/TODO,v 1.1150 2003/10/10 01:52:15 momjian Exp $ * Exit postmaster if postgresql.conf can not be opened * Rename /scripts directory because they are all C programs now * Allow the regression tests to start postmaster with -i so the tests |