PostgreSQL TODO List

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

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

Last updated:Sat Apr8 23:26:57 EDT 2006

Last updated:Sun Apr9 16:24:16 EDT 2006

The most recent version of this document can be viewed at

http://www.postgresql.org/docs/faqs.TODO.html.

Startup Time Improvements

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

* Experiment with multi-threaded backend [thread]

* Experiment with multi-threaded backendfor backend creation[thread]

This would prevent the overhead associated with process creation. Most

operating systems have trivial process creation time compared to

database startup overhead, but a few operating systems (Win32,

Solaris) might benefit from threading. Also explore the idea of

a single session using multiple threads to execute a statement faster.

* Experiment with multi-threaded backend better resource utilization

This would allow a single query to make use of multiple CPU's or

multiple I/O channels simultaneously.

* Add connection pooling

It is unclear if this should be done inside the backend code or done

<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">

<h1><aname="section_1">PostgreSQL TODO List</a></h1>

<p>Current maintainer: Bruce Momjian (<ahref="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/>

Last updated:Sat Apr8 23:26:57 EDT 2006

Last updated:Sun Apr9 16:24:16 EDT 2006

<p>The most recent version of this document can be viewed at<br/>

<ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.

<h1><aname="section_18">Startup Time Improvements</a></h1>

<li>Experiment with multi-threaded backend [<ahref="http://momjian.postgresql.org/cgi-bin/pgtodo?thread">thread</a>]

<li>Experiment with multi-threaded backendfor backend creation[<ahref="http://momjian.postgresql.org/cgi-bin/pgtodo?thread">thread</a>]

<p> This would prevent the overhead associated with process creation. Most

operating systems have trivial process creation time compared to

database startup overhead, but a few operating systems (Win32,

Solaris) might benefit from threading. Also explore the idea of

a single session using multiple threads to execute a statement faster.

</li><li>Experiment with multi-threaded backend better resource utilization

<p> This would allow a single query to make use of multiple CPU's or

multiple I/O channels simultaneously.

</li><li>Add connection pooling

<p> It is unclear if this should be done inside the backend code or done