aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorNeil Conway <neilc@samurai.com>2007-01-16 20:58:38 +0000
committerNeil Conway <neilc@samurai.com>2007-01-16 20:58:38 +0000
commitda07c81fe3672fdc216b923f7abcde5d23ad0a6a (patch)
treee3e6f38109505c2dd8975ea313c5e28021622c22
parent6959cb59573975cc5b2913c0c3b97b5de5e3b56c (diff)
downloadpostgresql-da07c81fe3672fdc216b923f7abcde5d23ad0a6a.tar.gz
postgresql-da07c81fe3672fdc216b923f7abcde5d23ad0a6a.zip
Minor improvements to the TODO list. Add some URLs for some
existing TODO items, and re-add a TODO item for an "estimated count" capability.
-rw-r--r--doc/TODO14
1 files changed, 13 insertions, 1 deletions
diff --git a/doc/TODO b/doc/TODO
index 1b68a55501d..25b8faafaef 100644
--- a/doc/TODO
+++ b/doc/TODO
@@ -341,7 +341,7 @@ Functions
* Add ISO day of week format 'ID' to to_char() where Monday = 1
* Add a field 'isoyear' to extract(), based on the ISO week
* Add SPI_gettypmod() to return the typemod for a TupleDesc
-* Allow inlining of set-returning functions
+* Implement inlining of set-returning functions defined in SQL
* Allow SQL-language functions to return results from RETURNING queries
@@ -928,6 +928,8 @@ Indexes
several hash buckets could be stored on a single page and greater
granularity used for the hash algorithm.
+ http://archives.postgresql.org/pgsql-hackers/2004-06/msg00168.php
+
o Consider sorting hash buckets so entries can be found using a
binary search, rather than a linear scan
@@ -972,6 +974,13 @@ Cache Usage
faster than a sequential scan it must avoid access to the heap
to obtain tuple visibility information.
+* Provide a way to calculate an "estimated COUNT(*)"
+
+ Perhaps by using the optimizer's cardinality estimates or random
+ sampling.
+
+ http://archives.postgresql.org/pgsql-hackers/2005-11/msg00943.php
+
* Allow data to be pulled directly from indexes
Currently indexes do not have enough tuple visibility information
@@ -1075,6 +1084,9 @@ Locking
* Fix priority ordering of read and write light-weight locks (Neil)
+ http://archives.postgresql.org/pgsql-hackers/2004-11/msg00893.php
+ http://archives.postgresql.org/pgsql-hackers/2004-11/msg00905.php
+
Startup Time Improvements
=========================