diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-08-13 04:32:28 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-08-13 04:32:28 +0000 |
| commit | b6d8df67d346ff59cfa19bba7d7e42e6c2132cd6 (patch) | |
| tree | 0fc309f54e6ba75ed5ceba774cb41b3660e762ac | |
| parent | 282a5884de21e20cdc849457270c89ed05543722 (diff) | |
| download | postgresql-b6d8df67d346ff59cfa19bba7d7e42e6c2132cd6.tar.gz postgresql-b6d8df67d346ff59cfa19bba7d7e42e6c2132cd6.zip | |
Update:
> * Use bitmaps to fetch heap pages in sequential order [performance]
> * Use bitmaps to combine existing indexes [performance]
| -rw-r--r-- | doc/TODO | 5 |
1 files changed, 3 insertions, 2 deletions
@@ -1,6 +1,6 @@ TODO list for PostgreSQL ======================== -Last updated: Thu Aug 8 19:50:27 EDT 2002 +Last updated: Tue Aug 13 00:32:10 EDT 2002 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -159,7 +159,8 @@ Indexes * Be smarter about insertion of already-ordered data into btree index * -Add deleted bit to index tuples to reduce heap access * Prevent index uniqueness checks when UPDATE does not modifying column -* Add bitmap indexes [performance] +* Use bitmaps to fetch heap pages in sequential order [performance] +* Use bitmaps to combine existing indexes [performance] * Improve handling of index scans for NULL * Allow SELECT * FROM tab WHERE int2col = 4 to use int2col index, int8, float4, numeric/decimal too [optimizer] |