Skip to content

Commit da07c81

Browse files
author
Neil Conway
committed
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.
1 parent 6959cb5 commit da07c81

File tree

1 file changed

+13
-1
lines changed

1 file changed

+13
-1
lines changed

doc/TODO

Lines changed: 13 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -341,7 +341,7 @@ Functions
341341
* Add ISO day of week format 'ID' to to_char() where Monday = 1
342342
* Add a field 'isoyear' to extract(), based on the ISO week
343343
* Add SPI_gettypmod() to return the typemod for a TupleDesc
344-
* Allow inlining of set-returning functions
344+
* Implement inlining of set-returning functions defined in SQL
345345
* Allow SQL-language functions to return results from RETURNING queries
346346

347347

@@ -928,6 +928,8 @@ Indexes
928928
several hash buckets could be stored on a single page and greater
929929
granularity used for the hash algorithm.
930930

931+
http://archives.postgresql.org/pgsql-hackers/2004-06/msg00168.php
932+
931933
o Consider sorting hash buckets so entries can be found using a
932934
binary search, rather than a linear scan
933935

@@ -972,6 +974,13 @@ Cache Usage
972974
faster than a sequential scan it must avoid access to the heap
973975
to obtain tuple visibility information.
974976

977+
* Provide a way to calculate an "estimated COUNT(*)"
978+
979+
Perhaps by using the optimizer's cardinality estimates or random
980+
sampling.
981+
982+
http://archives.postgresql.org/pgsql-hackers/2005-11/msg00943.php
983+
975984
* Allow data to be pulled directly from indexes
976985

977986
Currently indexes do not have enough tuple visibility information
@@ -1075,6 +1084,9 @@ Locking
10751084

10761085
* Fix priority ordering of read and write light-weight locks (Neil)
10771086

1087+
http://archives.postgresql.org/pgsql-hackers/2004-11/msg00893.php
1088+
http://archives.postgresql.org/pgsql-hackers/2004-11/msg00905.php
1089+
10781090

10791091
Startup Time Improvements
10801092
=========================

0 commit comments

Comments
 (0)