TODO list for PostgreSQL

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

Last updated:Mon Feb 17 13:46:07 EST 2003

Last updated:Mon Feb 17 13:48:20 EST 2003

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

* CLUSTER

o Automatically maintain clustering on a table

o Allow CLUSTER to cluster all tables (Alvaro Herrera)

o-Allow CLUSTER to cluster all tables (Alvaro Herrera)

* COPY

o Allow dump/load of CSV format

* Allow psql to show transaction status if backend protocol changes made

* Add XML interface: psql, pg_dump, COPY, separate server (?)

* -Add schema, cast, and conversion backslash commands to psql (Christopher)

* Allow pg_dump to dump a specific schema (Neil Conway)

*-Allow pg_dump to dump a specific schema (Neil Conway)

* Allow psql to do table completion for SELECT * FROM schema_part and

table completion for SELECT * FROM schema_name.

* Allow Subplans to use efficient joins(hash, merge) with upper variable

* -Add hash for evaluating GROUP BY aggregates (Tom)

* Allow merge and hash joins on expressions not just simple variables (Tom)

* Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS (Tom)

*-Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS (Tom)

* Missing optimizer selectivities for date, r-tree, etc. [optimizer]

* Allow ORDER BY ... LIMIT to select top values without sort or index

using a sequential scan for highest/lowest values (Oleg)