From 2d0b1660056657ff56b692b21c36c0c2ed874ee8 Mon Sep 17 00:00:00 2001
From: Marko Kreen <markokr@gmail.com>
Date: Fri, 4 Dec 2009 11:15:18 +0000
Subject: [PATCH] todo update

---
 doc/todo.txt | 26 +++++++++++++++++++++-----
 1 file changed, 21 insertions(+), 5 deletions(-)

diff --git a/doc/todo.txt b/doc/todo.txt
index b66b0f0..1c5f78f 100644
--- a/doc/todo.txt
+++ b/doc/todo.txt
@@ -1,21 +1,34 @@
 = PgBouncer TODO list =
 
+== Slightly urgent features ==
+
+ * move to libusual
+ * auth_conn - access to pg_shadow, so auth_file is not needed.
+   [ flat-text files are gone in 8.5+ ]
+ * per_loop_maint/per_loop_activate take too much time in case
+   of moderate load and lots of pools.  Perhaps active_pool_list
+   would help, which contains only pools touched in current loop.
+ * new states for clients: idle and in-query.  That allows to apply
+   client_idle_timeout and query_timeout without walking all clients
+   on maintenance time.
+
+== Good-to-have features in transaction pooling ==
+
+ * Protocol-level plan cache.
+ * LISTEN/NOTIFY.  Requires strict SQL format.
+
 == Minor features ==
 
  * duplication: format_time vs. render_time
    - avoid localtime? (libc stat)
  * set server_reset_query = '';
  * check if SQL error codes are correct
- * login cleanup / more useful
  * removing user should work - kill connections
  * keep stats about error counts
  * cleanup of logging levels, to make log more useful
  * to test:
    - signal flood
    - no mem / no fds handling
- * new states for clients: idle and in-query.  That allows to apply
-   client_idle_timeout and query_timeout without walking all clients
-   on maintenance time.
  * fix high-freq maintenance timer - it's only needed when
    PAUSE/RESUME/shutdown is issued.
  * Get rid of SBUF_SMALL_PKT logic - it makes processing code complex.
@@ -38,10 +51,13 @@
  * some preliminary notification that fd limit is full
 
  * Move all "look-at-full-packet" situtations to SBUF_EV_PKT_CALLBACK
- * auth_conn - access to pg_shadow, so auth_file is not needed
 
  * pid mapping for NOTIFY.
 
+ * `pool_mode = plproxy` - use postgres in full-duplex mode for autocommit
+   queries, multiplexing several queries into one connection.  Should result
+   in more effiicent CPU usage of server.
+
 === prepared plans ===
 
  * keeping track of protocol-level prepared plans
-- 
2.40.0