Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit7de0a91

Browse files
committed
Move "Exotic Features" to the bottom of TODO.
1 parent1e05359 commit7de0a91

File tree

2 files changed

+70
-69
lines changed

2 files changed

+70
-69
lines changed

‎doc/TODO‎

Lines changed: 32 additions & 31 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
PostgreSQL TODO List
33
====================
44
Current maintainer:Bruce Momjian (bruce@momjian.us)
5-
Last updated:Fri Sep 29 23:55:30 EDT 2006
5+
Last updated:Mon Oct 2 09:59:50 EDT 2006
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -849,36 +849,6 @@ Dependency Checking
849849
invalidate its own query plan.
850850

851851

852-
Exotic Features
853-
===============
854-
855-
* Add pre-parsing phase that converts non-ISO syntax to supported
856-
syntax
857-
858-
This could allow SQL written for other databases to run without
859-
modification.
860-
861-
* Allow plug-in modules to emulate features from other databases
862-
* SQL*Net listener that makes PostgreSQL appear as an Oracle database
863-
to clients
864-
* Allow statements across databases or servers with transaction
865-
semantics
866-
867-
This can be done using dblink and two-phase commit.
868-
869-
* Add the features of packages
870-
871-
o Make private objects accessible only to objects in the same schema
872-
o Allow current_schema.objname to access current schema objects
873-
o Add session variables
874-
o Allow nested schemas
875-
876-
* Consider allowing control of upper/lower case folding of unquoted
877-
identifiers
878-
879-
http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php
880-
881-
882852
Indexes
883853
=======
884854

@@ -1364,6 +1334,37 @@ Source Code
13641334
of result sets using new statement protocol
13651335

13661336

1337+
Exotic Features
1338+
===============
1339+
1340+
* Add pre-parsing phase that converts non-ISO syntax to supported
1341+
syntax
1342+
1343+
This could allow SQL written for other databases to run without
1344+
modification.
1345+
1346+
* Allow plug-in modules to emulate features from other databases
1347+
* SQL*Net listener that makes PostgreSQL appear as an Oracle database
1348+
to clients
1349+
* Allow statements across databases or servers with transaction
1350+
semantics
1351+
1352+
This can be done using dblink and two-phase commit.
1353+
1354+
* Add the features of packages
1355+
1356+
o Make private objects accessible only to objects in the same schema
1357+
o Allow current_schema.objname to access current schema objects
1358+
o Add session variables
1359+
o Allow nested schemas
1360+
1361+
* Consider allowing control of upper/lower case folding of unquoted
1362+
identifiers
1363+
1364+
http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php
1365+
1366+
1367+
13671368
Features We Do _Not_ Want
13681369
=========================
13691370

‎doc/src/FAQ/TODO.html‎

Lines changed: 38 additions & 38 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">
99
<h1><aname="section_1">PostgreSQL TODO List</a></h1>
1010
<p>Current maintainer: Bruce Momjian (<ahref="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/>
11-
Last updated:Fri Sep 29 23:55:30 EDT 2006
11+
Last updated:Mon Oct 2 09:59:50 EDT 2006
1212
</p>
1313
<p>The most recent version of this document can be viewed at<br/>
1414
<ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
@@ -769,34 +769,7 @@ <h1><a name="section_11">Dependency Checking</a></h1>
769769
invalidate its own query plan.
770770
</p>
771771
</li></ul>
772-
<h1><aname="section_12">Exotic Features</a></h1>
773-
774-
<ul>
775-
<li>Add pre-parsing phase that converts non-ISO syntax to supported
776-
syntax
777-
<p> This could allow SQL written for other databases to run without
778-
modification.
779-
</p>
780-
</li><li>Allow plug-in modules to emulate features from other databases
781-
</li><li>SQL*Net listener that makes PostgreSQL appear as an Oracle database
782-
to clients
783-
</li><li>Allow statements across databases or servers with transaction
784-
semantics
785-
<p> This can be done using dblink and two-phase commit.
786-
</p>
787-
</li><li>Add the features of packages
788-
<ul>
789-
<li>Make private objects accessible only to objects in the same schema
790-
</li><li>Allow current_schema.objname to access current schema objects
791-
</li><li>Add session variables
792-
</li><li>Allow nested schemas
793-
</li></ul>
794-
</li><li>Consider allowing control of upper/lower case folding of unquoted
795-
identifiers
796-
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php">http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php</a>
797-
</p>
798-
</li></ul>
799-
<h1><aname="section_13">Indexes</a></h1>
772+
<h1><aname="section_12">Indexes</a></h1>
800773

801774
<ul>
802775
<li>Allow inherited tables to inherit index, UNIQUE constraint, and primary
@@ -862,7 +835,7 @@ <h1><a name="section_13">Indexes</a></h1>
862835
</li><li>Allow multi-column hash indexes
863836
</li></ul>
864837
</li></ul>
865-
<h1><aname="section_14">Fsync</a></h1>
838+
<h1><aname="section_13">Fsync</a></h1>
866839

867840
<ul>
868841
<li>Improve commit_delay handling to reduce fsync()
@@ -874,7 +847,7 @@ <h1><a name="section_14">Fsync</a></h1>
874847
</li><li>%Add an option to sync() before fsync()'ing checkpoint files
875848
</li><li>Add program to test if fsync has a delay compared to non-fsync
876849
</li></ul>
877-
<h1><aname="section_15">Cache Usage</a></h1>
850+
<h1><aname="section_14">Cache Usage</a></h1>
878851

879852
<ul>
880853
<li>Allow free-behind capability for large sequential scans, perhaps using
@@ -928,7 +901,7 @@ <h1><a name="section_15">Cache Usage</a></h1>
928901
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2005-10/msg01419.php">http://archives.postgresql.org/pgsql-hackers/2005-10/msg01419.php</a>
929902
</p>
930903
</li></ul>
931-
<h1><aname="section_16">Vacuum</a></h1>
904+
<h1><aname="section_15">Vacuum</a></h1>
932905

933906
<ul>
934907
<li>Improve speed with indexes
@@ -987,12 +960,12 @@ <h1><a name="section_16">Vacuum</a></h1>
987960
</p>
988961
</li></ul>
989962
</li></ul>
990-
<h1><aname="section_17">Locking</a></h1>
963+
<h1><aname="section_16">Locking</a></h1>
991964

992965
<ul>
993966
<li>Fix priority ordering of read and write light-weight locks (Neil)
994967
</li></ul>
995-
<h1><aname="section_18">Startup Time Improvements</a></h1>
968+
<h1><aname="section_17">Startup Time Improvements</a></h1>
996969

997970
<ul>
998971
<li>Experiment with multi-threaded backend for backend creation [<ahref="http://momjian.postgresql.org/cgi-bin/pgtodo?thread">thread</a>]
@@ -1015,7 +988,7 @@ <h1><a name="section_18">Startup Time Improvements</a></h1>
1015988
existing backends is one of the difficulties with a backend approach.
1016989
</p>
1017990
</li></ul>
1018-
<h1><aname="section_19">Write-Ahead Log</a></h1>
991+
<h1><aname="section_18">Write-Ahead Log</a></h1>
1019992

1020993
<ul>
1021994
<li>Eliminate need to write full pages to WAL before page modification [<ahref="http://momjian.postgresql.org/cgi-bin/pgtodo?wal">wal</a>]
@@ -1079,7 +1052,7 @@ <h1><a name="section_19">Write-Ahead Log</a></h1>
10791052
of indexes on TOAST tables.
10801053
</p>
10811054
</li></ul>
1082-
<h1><aname="section_20">Optimizer / Executor</a></h1>
1055+
<h1><aname="section_19">Optimizer / Executor</a></h1>
10831056

10841057
<ul>
10851058
<li>Improve selectivity functions for geometric operators
@@ -1104,7 +1077,7 @@ <h1><a name="section_20">Optimizer / Executor</a></h1>
11041077
<p> This might replace GEQO,<ahref="http://sixdemonbag.org/Djinni">http://sixdemonbag.org/Djinni</a>.
11051078
</p>
11061079
</li></ul>
1107-
<h1><aname="section_21">Miscellaneous Performance</a></h1>
1080+
<h1><aname="section_20">Miscellaneous Performance</a></h1>
11081081

11091082
<ul>
11101083
<li>Do async I/O for faster random read-ahead of data
@@ -1158,7 +1131,7 @@ <h1><a name="section_21">Miscellaneous Performance</a></h1>
11581131
</li><li>Reduce the row header size?
11591132
</li></ul>
11601133
</li></ul>
1161-
<h1><aname="section_22">Source Code</a></h1>
1134+
<h1><aname="section_21">Source Code</a></h1>
11621135

11631136
<ul>
11641137
<li>Add use of 'const' for variables in source tree
@@ -1231,6 +1204,33 @@ <h1><a name="section_22">Source Code</a></h1>
12311204
of result sets using new statement protocol
12321205
</li></ul>
12331206
</li></ul>
1207+
<h1><aname="section_22">Exotic Features</a></h1>
1208+
1209+
<ul>
1210+
<li>Add pre-parsing phase that converts non-ISO syntax to supported
1211+
syntax
1212+
<p> This could allow SQL written for other databases to run without
1213+
modification.
1214+
</p>
1215+
</li><li>Allow plug-in modules to emulate features from other databases
1216+
</li><li>SQL*Net listener that makes PostgreSQL appear as an Oracle database
1217+
to clients
1218+
</li><li>Allow statements across databases or servers with transaction
1219+
semantics
1220+
<p> This can be done using dblink and two-phase commit.
1221+
</p>
1222+
</li><li>Add the features of packages
1223+
<ul>
1224+
<li>Make private objects accessible only to objects in the same schema
1225+
</li><li>Allow current_schema.objname to access current schema objects
1226+
</li><li>Add session variables
1227+
</li><li>Allow nested schemas
1228+
</li></ul>
1229+
</li><li>Consider allowing control of upper/lower case folding of unquoted
1230+
identifiers
1231+
<p><ahref="http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php">http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php</a>
1232+
</p>
1233+
</li></ul>
12341234
<h1><aname="section_23">Features We Do _Not_ Want</a></h1>
12351235

12361236
<ul>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp