pgsql: Spit items: * Experiment with multi-threaded backend better I/O

From: momjian(at)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Spit items: * Experiment with multi-threaded backend better I/O
Date: 2008-03-18 23:35:22
Message-ID: 20080318233522.04D2D7558DC@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Spit items:

* Experiment with multi-threaded backend better I/O utilization

This would allow a single query to make use of multiple I/O channels
simultaneously. One idea is to create a background reader that can
pre-fetch sequential and index scan pages needed by other backends.
This could be expanded to allow concurrent reads from multiple devices
in a partitioned table.

* Experiment with multi-threaded backend better CPU utilization

This would allow several CPUs to be used for a single query, such as
for sorting or query execution.

Modified Files:
--------------
pgsql/doc:
TODO (r1.2349 -> r1.2350)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1.2349&r2=1.2350)
pgsql/doc/src/FAQ:
TODO.html (r1.857 -> r1.858)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html?r1=1.857&r2=1.858)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2008-03-18 23:35:42 Re: Re: pgsql: Add URLs for : * Speed WAL recovery by allowing more than one
Previous Message Bruce Momjian 2008-03-18 23:32:57 pgsql: Update TODO description: * Speed WAL recovery by allowing more