PostgreSQL TODO List

====================

Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)

Last updated:Fri Apr 2209:38:10 EDT 2005

Last updated:Fri Apr 2211:40:08 EDT 2005

The most recent version of this document can be viewed at

http://www.postgresql.org/docs/faqs.TODO.html.

* Allow data to be pulled directly from indexes

Currently indexes do not have enough tupletuplevisibility

informationto allow data to be pulled from the index without

also accessingthe heap. One way to allow this is to set a bit

toindex tuples toindicate if a tuple is currently visible to

all transactionswhen the first valid heap lookup happens. This

bit would have tobe cleared when a heap tuple is expired.

Currently indexes do not have enough tuple visibility information

to allow data to be pulled from the index without also accessing

the heap. One way to allow this is to set a bit to index tuples

to indicate if a tuple is currently visible to all transactions

when the first valid heap lookup happens. This bit would have to

be cleared when a heap tuple is expired.

* Consider automatic caching of queries at various levels:

o Parsed query tree

<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">

<h1><aname="section_1">PostgreSQL TODO List</a></h1>

<p>Current maintainer: Bruce Momjian (<ahref="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/>

Last updated: Fri Apr 2209:38:10 EDT 2005

Last updated: Fri Apr 2211:40:08 EDT 2005

<p>The most recent version of this document can be viewed at<br/>

<ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.

to obtain tuple visibility information.

</li><li>Allow data to be pulled directly from indexes

<p> Currently indexes do not have enough tupletuplevisibility

informationto allow data to be pulled from the index without

also accessingthe heap. One way to allow this is to set a bit

toindex tuples toindicate if a tuple is currently visible to

all transactionswhen the first valid heap lookup happens. This

bit would have tobe cleared when a heap tuple is expired.

<p> Currently indexes do not have enough tuple visibility information

to allow data to be pulled from the index without also accessing

the heap. One way to allow this is to set a bit to index tuples

to indicate if a tuple is currently visible to all transactions

when the first valid heap lookup happens. This bit would have to

be cleared when a heap tuple is expired.

</li><li>Consider automatic caching of queries at various levels: