PostgreSQL TODO List

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

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

Last updated:Wed Jun 823:00:21 EDT 2005

Last updated:Mon Jun1323:19:51 EDT 2005

The most recent version of this document can be viewed at

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

BY col {DESC} LIMIT 1. Completing this item involves doing this

transformation automatically.

* Use index to restrict rows returned by multi-key index when used with

*-Use index to restrict rows returned by multi-key index when used with

non-consecutive keys to reduce heap accesses

For an index on col1,col2,col3, and a WHERE clause of col1 = 5 and

<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:Wed Jun 823:00:21 EDT 2005

Last updated:Mon Jun1323:19:51 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>.

BY col {DESC} LIMIT 1. Completing this item involves doing this

transformation automatically.

</li><li>Use index to restrict rows returned by multi-key index when used with

</li><li>-<em>Use index to restrict rows returned by multi-key index when used with</em>

non-consecutive keys to reduce heap accesses

<p> 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,