diff options
author | Bruce Momjian | 2004-11-04 16:49:53 +0000 |
---|---|---|
committer | Bruce Momjian | 2004-11-04 16:49:53 +0000 |
commit | 2c793d1c87b1081021319dace49010e2f42dce0a (patch) | |
tree | beca736feac71f7e6542715359ecca3d868556c4 | |
parent | c894e7e8e06e88fc6d54081818b30f123a117dbd (diff) |
Updates from Simon Riggs:
< that can spam more than one table.
> that can span more than one table.
239c239
< rather than just col1
> rather than just col1; also called skip-scanning.
641c641,642
< * Add free-behind capability for large sequential scans [fadvise]
> * Allow free-behind capability for large sequential scans, perhaps using
> posix_fadvise() [fadvise]
-rw-r--r-- | doc/TODO | 9 |
1 files changed, 5 insertions, 4 deletions
@@ -5,7 +5,7 @@ TODO list for PostgreSQL Bracketed items "[]" have more detail. Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) -Last updated: Thu Nov 4 11:19:28 EST 2004 +Last updated: Thu Nov 4 11:49:35 EST 2004 The most recent version of this document can be viewed at the PostgreSQL web site, http://www.PostgreSQL.org. @@ -221,7 +221,7 @@ Indexes (dup) should fail [inheritance] The main difficulty with this item is the problem of creating an index - that can spam more than one table. + that can span more than one table. * Add UNIQUE capability to non-btree indexes * Add rtree index support for line, lseg, path, point @@ -236,7 +236,7 @@ Indexes For an index on col1,col2,col3, and a WHERE clause of col1 = 5 and col3 = 9, spin though the index checking for col1 and col3 matches, - rather than just col1 + rather than just col1; also called skip-scanning. * Prevent index uniqueness checks when UPDATE does not modify the column @@ -638,7 +638,8 @@ Fsync Cache ===== -* Add free-behind capability for large sequential scans [fadvise] +* Allow free-behind capability for large sequential scans, perhaps using + posix_fadvise() [fadvise] * Consider use of open/fcntl(O_DIRECT) to minimize OS caching * Cache last known per-tuple offsets to speed long tuple access |