diff options
author | Neil Conway <neilc@samurai.com> | 2007-01-16 20:58:38 +0000 |
---|---|---|
committer | Neil Conway <neilc@samurai.com> | 2007-01-16 20:58:38 +0000 |
commit | da07c81fe3672fdc216b923f7abcde5d23ad0a6a (patch) | |
tree | e3e6f38109505c2dd8975ea313c5e28021622c22 | |
parent | 6959cb59573975cc5b2913c0c3b97b5de5e3b56c (diff) | |
download | postgresql-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/TODO | 14 |
1 files changed, 13 insertions, 1 deletions
@@ -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 ========================= |