On Tue, 09 Sep 2008 10:07:32 -0600, Scott Marlowe wrote: > On Tue, Sep 9, 2008 at 9:35 AM, Amber <guxiaobo1982@xxxxxxxxxxx> wrote: >> We know PostgreSQL uses one dedicated server process to serve one client >> connection, what we want to know is whether PostgreSQL use multiple threads >> inside agents processes to take advantage of multiple CPUs. In our site we >> have only a few concurrent connections, so what occurs inside agent process >> is very important to us. > > No it doesn't. One connection gets one process which uses one CPU at a time. I understand the history/technical reasons/motivation for this, yet want to ask if anybody has thought about using OpenMP for careful parallelization of per-process work sections? Scanning large (e.g. already locked) arrays, parallel sweeps or calculations might benefit from parallelizatoin without requiring a full-out threaded design. Such an approach could retain the per-process isolation model yet still reap multicore benefits. To boot OpenMP is pretty easy to use and comes with gcc. Since I don't know much about PG's internals and their data dependencies etc. this might well be a dumb idea, but I figured asking couldn't hurt. :) regards Holger
