Skip to content

Commit d32f247

Browse files
committed
Remove completed 8.3 TODO items:
< o -Allow commenting of variables in postgresql.conf to restore them < to defaults < o -Add a GUC variable to control the tablespace for temporary objects < and sort files < Monitoring < ========== < < * -Allow server log information to be output as CSV format < * -Add ability to monitor the use of temporary sort files < * -Allow user-defined types to accept 'typmod' parameters < < http://archives.postgresql.org/pgsql-hackers/2005-08/msg01142.php < http://archives.postgresql.org/pgsql-hackers/2005-09/msg00012.php < http://archives.postgresql.org/pgsql-hackers/2006-08/msg00149.php < < * -Add Globally/Universally Unique Identifier (GUID/UUID) < < http://archives.postgresql.org/pgsql-patches/2006-09/msg00209.php < http://archives.postgresql.org/pgsql-general/2007-01/msg00853.php < < * -Support a data type with specific enumerated values (ENUM) < o -Add support for arrays of complex types < o -Make 64-bit version of the MONEY data type < * -Add ISO day of week format 'ID' to to_char() where Monday = 1 < * -Add a field 'isoyear' to extract(), based on the ISO week < * -Add RESET SESSION command to reset all session state < o -Make CLUSTER preserve recently-dead tuples per MVCC requirements < o -Add more logical syntax CLUSTER table USING index; < support current syntax for backward compatibility < o -Allow UPDATE/DELETE WHERE CURRENT OF cursor < o -Add support for MOVE cursors < o -Allow PL/PythonU to return boolean rather than 1/0 < o -Allow psql \pset boolean variables to set to fixed values, rather < than toggle < o -Add -f to pg_dumpall < Dependency Checking < =================== < < * -Flush cached query plans when the dependent objects change or < when new ANALYZE statistics are available < * -Track dependencies in function bodies and recompile/invalidate < * -Invalidate prepared queries, like INSERT, when the table definition < is altered < < * -Allow use of indexes to search for NULLs < * -Allow the creation of indexes with mixed ascending/descending < specifiers < * -Reduce checkpoint performance degredation by forcing data to disk < more evenly < * -Allow sequential scans to take advantage of other concurrent < sequential scans, also called "Synchronised Scanning" < * -Consider shrinking expired tuples to just their headers < * -Allow heap reuse of UPDATEd rows if no indexed columns are changed, < and old and new versions are on the same heap page < * -Reduce XID consumption of read-only queries < o -Turn on by default < o -Allow multiple vacuums so large tables do not starve small < tables < * -Allow the pg_xlog directory location to be specified during initdb < with a symlink back to the /data location < * -Allow buffered WAL writes and fsync < * -Allow ORDER BY ... LIMIT # to select high/low value without sort or < index using a sequential scan for highest/lowest values < * -Merge xmin/xmax/cmin/cmax back into three header fields < o -Support a smaller header for short variable-length fields < * -Move NAMEDATALEN from postgres_ext.h to pg_config_manual.h < * -Fix problem with excessive logging during SSL disconnection < < http://archives.postgresql.org/pgsql-bugs/2006-12/msg00122.php < http://archives.postgresql.org/pgsql-bugs/2007-05/msg00065.php < < o -Add long file support for binary pg_dump output
1 parent 6b8d26b commit d32f247

File tree

2 files changed

+28
-172
lines changed

2 files changed

+28
-172
lines changed

doc/TODO

Lines changed: 1 addition & 73 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
PostgreSQL TODO List
22
====================
33
Current maintainer: Bruce Momjian (bruce@momjian.us)
4-
Last updated: Mon Nov 26 18:31:05 EST 2007
4+
Last updated: Fri Dec 7 12:52:05 EST 2007
55

66
The most recent version of this document can be viewed at
77
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -100,8 +100,6 @@ Administration
100100

101101
* Configuration files
102102

103-
o -Allow commenting of variables in postgresql.conf to restore them
104-
to defaults
105103
o Allow pg_hba.conf to specify host names along with IP addresses
106104

107105
Host name lookup could occur when the postmaster reads the
@@ -142,8 +140,6 @@ Administration
142140
requires a tool that will call that function and connect to each
143141
database to find the objects in each database for that tablespace.
144142

145-
o -Add a GUC variable to control the tablespace for temporary objects
146-
and sort files
147143
o Allow WAL replay of CREATE TABLESPACE to work when the directory
148144
structure on the recovery computer is different from the original
149145

@@ -168,11 +164,6 @@ Administration
168164
http://archives.postgresql.org/pgsql-hackers/2006-12/msg00497.php
169165

170166

171-
Monitoring
172-
==========
173-
174-
* -Allow server log information to be output as CSV format
175-
* -Add ability to monitor the use of temporary sort files
176167

177168

178169
Data Types
@@ -187,12 +178,6 @@ Data Types
187178
* Fix data types where equality comparison isn't intuitive, e.g. box
188179
* Allow user-defined types to specify a type modifier at table creation
189180
time
190-
* -Allow user-defined types to accept 'typmod' parameters
191-
192-
http://archives.postgresql.org/pgsql-hackers/2005-08/msg01142.php
193-
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00012.php
194-
http://archives.postgresql.org/pgsql-hackers/2006-08/msg00149.php
195-
196181
* Add support for public SYNONYMs
197182

198183
http://archives.postgresql.org/pgsql-hackers/2006-03/msg00519.php
@@ -202,19 +187,13 @@ Data Types
202187
http://archives.postgresql.org/pgsql-hackers/2006-05/msg00072.php
203188
http://archives.postgresql.org/pgsql-hackers/2006-09/msg01681.php
204189

205-
* -Add Globally/Universally Unique Identifier (GUID/UUID)
206-
207-
http://archives.postgresql.org/pgsql-patches/2006-09/msg00209.php
208-
http://archives.postgresql.org/pgsql-general/2007-01/msg00853.php
209-
210190
* Add support for SQL-standard GENERATED/IDENTITY columns
211191

212192
http://archives.postgresql.org/pgsql-hackers/2006-07/msg00543.php
213193
http://archives.postgresql.org/pgsql-hackers/2006-08/msg00038.php
214194
http://archives.postgresql.org/pgsql-hackers/2007-05/msg00344.php
215195
http://archives.postgresql.org/pgsql-patches/2007-05/msg00076.php
216196

217-
* -Support a data type with specific enumerated values (ENUM)
218197
* Improve XML support
219198

220199
http://developer.postgresql.org/index.php/XML_Support
@@ -308,7 +287,6 @@ Data Types
308287

309288
http://archives.postgresql.org/pgsql-patches/2007-05/msg00114.php
310289

311-
o -Add support for arrays of complex types
312290
o Allow single-byte header storage for array elements
313291

314292

@@ -330,7 +308,6 @@ Data Types
330308

331309
* MONEY data type
332310

333-
o -Make 64-bit version of the MONEY data type
334311
* Add locale-aware MONEY type, and support multiple currencies
335312

336313
http://archives.postgresql.org/pgsql-general/2005-08/msg01432.php
@@ -369,8 +346,6 @@ Functions
369346
o to_char(INTERVAL '43 hours 20 minutes', 'WK:DD:HR:MI') => 0:1:19:20
370347
o to_char(INTERVAL '3 years 5 months','MM') => 41
371348

372-
* -Add ISO day of week format 'ID' to to_char() where Monday = 1
373-
* -Add a field 'isoyear' to extract(), based on the ISO week
374349
* Implement inlining of set-returning functions defined in SQL
375350
* Allow SQL-language functions to return results from RETURNING queries
376351

@@ -539,7 +514,6 @@ SQL Commands
539514

540515
* Add NOVICE output level for helpful messages like automatic sequence/index
541516
creation
542-
* -Add RESET SESSION command to reset all session state
543517
* Add GUC to issue notice about statements that use unjoined tables
544518
* Allow EXPLAIN to identify tables that were skipped because of
545519
constraint_exclusion
@@ -652,7 +626,6 @@ SQL Commands
652626

653627
* CLUSTER
654628

655-
o -Make CLUSTER preserve recently-dead tuples per MVCC requirements
656629
o Automatically maintain clustering on a table
657630

658631
This might require some background daemon to maintain clustering
@@ -671,8 +644,6 @@ SQL Commands
671644

672645
o %Add VERBOSE option to report tables as they are processed,
673646
like VACUUM VERBOSE
674-
o -Add more logical syntax CLUSTER table USING index;
675-
support current syntax for backward compatibility
676647

677648

678649
* COPY
@@ -709,7 +680,6 @@ SQL Commands
709680

710681
* CURSOR
711682

712-
o -Allow UPDATE/DELETE WHERE CURRENT OF cursor
713683
o Prevent DROP TABLE from dropping a row referenced by its own open
714684
cursor?
715685

@@ -784,7 +754,6 @@ SQL Commands
784754
http://archives.postgresql.org/pgsql-patches/2006-06/msg00031.php
785755

786756
o Add single-step debugging of functions
787-
o -Add support for MOVE cursors
788757
o Add support for SCROLL cursors
789758
o Add support for WITH HOLD cursors
790759
o Allow RETURN to return row or record functions
@@ -817,7 +786,6 @@ SQL Commands
817786

818787
http://archives.postgresql.org/pgsql-patches/2006-02/msg00288.php
819788

820-
o -Allow PL/PythonU to return boolean rather than 1/0
821789
o Allow data to be passed in native language formats, rather
822790
than only text
823791

@@ -855,8 +823,6 @@ Clients
855823
http://archives.postgresql.org/pgsql-hackers/2004-11/msg00014.php
856824
http://archives.postgresql.org/pgsql-hackers/2004-11/msg00014.php
857825

858-
o -Allow psql \pset boolean variables to set to fixed values, rather
859-
than toggle
860826
o Consistently display privilege information for all objects in psql
861827
o Add auto-expanded mode so expanded output is used if the row
862828
length is wider than the screen width.
@@ -901,7 +867,6 @@ Clients
901867
o Stop dumping CASCADE on DROP TYPE commands in clean mode
902868
o Allow pg_dump --clean to drop roles that own objects or have
903869
privileges
904-
o -Add -f to pg_dumpall
905870
o Change pg_dump so that a comment on the dumped database is
906871
applied to the loaded database, even if the database has a
907872
different name. This will require new backend syntax, perhaps
@@ -999,15 +964,6 @@ Triggers
999964

1000965

1001966

1002-
Dependency Checking
1003-
===================
1004-
1005-
* -Flush cached query plans when the dependent objects change or
1006-
when new ANALYZE statistics are available
1007-
* -Track dependencies in function bodies and recompile/invalidate
1008-
* -Invalidate prepared queries, like INSERT, when the table definition
1009-
is altered
1010-
1011967

1012968
Indexes
1013969
=======
@@ -1028,15 +984,12 @@ Indexes
1028984
http://archives.postgresql.org/pgsql-patches/2005-07/msg00512.php
1029985
http://archives.postgresql.org/pgsql-hackers/2006-12/msg01107.php
1030986

1031-
* -Allow use of indexes to search for NULLs
1032987
* Allow accurate statistics to be collected on indexes with more than
1033988
one column or expression indexes, perhaps using per-index statistics
1034989

1035990
http://archives.postgresql.org/pgsql-performance/2006-10/msg00222.php
1036991
http://archives.postgresql.org/pgsql-hackers/2007-03/msg01131.php
1037992

1038-
* -Allow the creation of indexes with mixed ascending/descending
1039-
specifiers
1040993
* Consider compressing indexes by storing key values duplicated in
1041994
several rows as a single index entry
1042995

@@ -1111,8 +1064,6 @@ Fsync
11111064

11121065
* %Add an option to sync() before fsync()'ing checkpoint files
11131066
* Add program to test if fsync has a delay compared to non-fsync
1114-
* -Reduce checkpoint performance degredation by forcing data to disk
1115-
more evenly
11161067

11171068

11181069
Cache Usage
@@ -1171,8 +1122,6 @@ Cache Usage
11711122
o Query execute plan
11721123
o Query results
11731124

1174-
* -Allow sequential scans to take advantage of other concurrent
1175-
sequential scans, also called "Synchronised Scanning"
11761125
* Consider increasing internal areas when shared buffers is increased
11771126

11781127
http://archives.postgresql.org/pgsql-hackers/2005-10/msg01419.php
@@ -1227,14 +1176,10 @@ Vacuum
12271176
in hopes that empty pages at the end can be truncated by VACUUM
12281177
* Allow FSM page return free space based on table clustering, to assist
12291178
in maintaining clustering?
1230-
* -Consider shrinking expired tuples to just their headers
1231-
* -Allow heap reuse of UPDATEd rows if no indexed columns are changed,
1232-
and old and new versions are on the same heap page
12331179
* Improve dead row detection during multi-statement transactions usage
12341180

12351181
http://archives.postgresql.org/pgsql-patches/2007-03/msg00358.php
12361182

1237-
* -Reduce XID consumption of read-only queries
12381183
* Prevent long-lived temporary tables from causing frozen-xid advancement
12391184
starvation
12401185

@@ -1249,9 +1194,6 @@ Vacuum
12491194
o %Issue log message to suggest VACUUM FULL if a table is nearly
12501195
empty?
12511196
o Consider logging activity either to the logs or a system view
1252-
o -Turn on by default
1253-
o -Allow multiple vacuums so large tables do not starve small
1254-
tables
12551197
o Improve control of auto-vacuum
12561198

12571199
http://archives.postgresql.org/pgsql-hackers/2006-12/msg00876.php
@@ -1344,8 +1286,6 @@ Write-Ahead Log
13441286

13451287
http://archives.postgresql.org/pgsql-hackers/2007-03/msg01589.php
13461288

1347-
* -Allow the pg_xlog directory location to be specified during initdb
1348-
with a symlink back to the /data location
13491289
* Allow WAL information to recover corrupted pg_controldata
13501290

13511291
http://archives.postgresql.org/pgsql-patches/2006-06/msg00025.php
@@ -1357,7 +1297,6 @@ Write-Ahead Log
13571297
rotation to fsync again. One idea is to write the WAL to different
13581298
offsets that might reduce the rotational delay.
13591299

1360-
* -Allow buffered WAL writes and fsync
13611300
* Allow WAL logging to be turned off for a table, but the table
13621301
might be dropped or truncated during crash recovery [walcontrol]
13631302

@@ -1382,8 +1321,6 @@ Optimizer / Executor
13821321
====================
13831322

13841323
* Improve selectivity functions for geometric operators
1385-
* -Allow ORDER BY ... LIMIT # to select high/low value without sort or
1386-
index using a sequential scan for highest/lowest values
13871324
* Precompile SQL functions to avoid overhead
13881325
* Create utility to compute accurate random_page_cost value
13891326
* Improve ability to display optimizer analysis using OPTIMIZER_DEBUG
@@ -1433,10 +1370,8 @@ Miscellaneous Performance
14331370
could hit disk before WAL is written.
14341371

14351372
* Add a script to ask system configuration questions and tune postgresql.conf
1436-
* -Merge xmin/xmax/cmin/cmax back into three header fields
14371373
* Consider ways of storing rows more compactly on disk
14381374

1439-
o -Support a smaller header for short variable-length fields
14401375
o Reduce the row header size?
14411376
o Consider reducing on-disk varlena length from four bytes to
14421377
two because a heap row cannot be more than 64k in length
@@ -1511,19 +1446,13 @@ Source Code
15111446

15121447
http://archives.postgresql.org/pgsql-docs/2006-12/msg00152.php
15131448

1514-
* -Move NAMEDATALEN from postgres_ext.h to pg_config_manual.h
15151449
* Consider making NAMEDATALEN more configurable in future releases
15161450
* Update our code to handle 64-bit timezone files to match the zic
15171451
source code, which now uses them
15181452
* Have configure choose integer datetimes by default
15191453

15201454
http://archives.postgresql.org/pgsql-patches/2007-05/msg00046.php
15211455

1522-
* -Fix problem with excessive logging during SSL disconnection
1523-
1524-
http://archives.postgresql.org/pgsql-bugs/2006-12/msg00122.php
1525-
http://archives.postgresql.org/pgsql-bugs/2007-05/msg00065.php
1526-
15271456
* Support scoped IPv6 addresses
15281457

15291458
http://archives.postgresql.org/pgsql-bugs/2007-05/msg00111.php
@@ -1552,7 +1481,6 @@ Source Code
15521481

15531482
http://archives.postgresql.org/pgsql-patches/2005-06/msg00027.php
15541483

1555-
o -Add long file support for binary pg_dump output
15561484

15571485

15581486
* Wire Protocol Changes

0 commit comments

Comments
 (0)