|
8 | 8 | <bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF"> |
9 | 9 | <h1><aname="section_1">PostgreSQL TODO List</a></h1> |
10 | 10 | <p>Current maintainer: Bruce Momjian (<ahref="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/> |
11 | | -Last updated: Tue Apr 1510:24:22 EDT 2008 |
| 11 | +Last updated: Tue Apr 1511:06:48 EDT 2008 |
12 | 12 | </p> |
13 | 13 | <p>The most recent version of this document can be viewed at<br/> |
14 | 14 | <ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>. |
@@ -522,19 +522,6 @@ <h1><a name="section_7">SQL Commands</a></h1> |
522 | 522 | </p> |
523 | 523 | </li><li>Improve logging of prepared transactions recovered during startup |
524 | 524 | <p><ahref="http://archives.postgresql.org/pgsql-hackers/2006-11/msg00092.php">http://archives.postgresql.org/pgsql-hackers/2006-11/msg00092.php</a> |
525 | | -</p> |
526 | | -</li><li>Allow LISTEN/NOTIFY to store info in memory rather than tables? |
527 | | -<p> Currently LISTEN/NOTIFY information is stored in pg_listener. Storing |
528 | | - such information in memory would improve performance. |
529 | | -</p> |
530 | | -</li><li>Add optional textual message to NOTIFY |
531 | | -<p> This would allow an informational message to be added to the notify |
532 | | - message, perhaps indicating the row modified or other custom |
533 | | - information. |
534 | | -</p> |
535 | | -</li><li>Allow multiple identical NOTIFY events to always be communicated to the |
536 | | - client, rather than sent as a single notification to the listener |
537 | | -<p><ahref="http://archives.postgresql.org/pgsql-general/2008-01/msg00057.php">http://archives.postgresql.org/pgsql-general/2008-01/msg00057.php</a> |
538 | 525 | </p> |
539 | 526 | </li><li>Add a GUC variable to warn about non-standard SQL usage in queries |
540 | 527 | </li><li>Add SQL-standard MERGE command, typically used to merge two tables |
@@ -758,6 +745,23 @@ <h1><a name="section_7">SQL Commands</a></h1> |
758 | 745 | <li>Add SET PERFORMANCE_TIPS option to suggest INDEX, VACUUM, VACUUM |
759 | 746 | ANALYZE, and CLUSTER |
760 | 747 | </li></ul> |
| 748 | +</li><li>LISTEN/NOTIFY |
| 749 | +<ul> |
| 750 | +<li>Allow LISTEN/NOTIFY to store info in memory rather than tables? |
| 751 | +<p> Currently LISTEN/NOTIFY information is stored in pg_listener. |
| 752 | + Storing such information in memory would improve performance. |
| 753 | +</p> |
| 754 | +</li><li>Add optional textual message to NOTIFY |
| 755 | +<p> This would allow an informational message to be added to the notify |
| 756 | + message, perhaps indicating the row modified or other custom |
| 757 | + information. |
| 758 | +</p> |
| 759 | +</li><li>Allow multiple identical NOTIFY events to always be communicated |
| 760 | + to the client, rather than sent as a single notification to the |
| 761 | + listener |
| 762 | +<p><ahref="http://archives.postgresql.org/pgsql-general/2008-01/msg00057.php">http://archives.postgresql.org/pgsql-general/2008-01/msg00057.php</a> |
| 763 | +</p> |
| 764 | +</li></ul> |
761 | 765 | </li></ul> |
762 | 766 | <h1><aname="section_8">Referential Integrity</a></h1> |
763 | 767 |
|
|