Re: PostgreSQL process architecture question.

That's it, we have 4 CPUs, each of which has 4 cores, that is we have 16 cores in total, but we have only 4 to 8 concurrent users, who regularly run complex queries. That is we can't use all our CPU resources in such a situation to speed up response time.

> To: pgsql-general(at)postgresql(dot)org> From: holger(at)wizards(dot)de> Subject: Re: [GENERAL] PostgreSQL process architecture question.> Date: Tue, 9 Sep 2008 18:30:17 +0200> > On Tue, 09 Sep 2008 10:07:32 -0600, Scott Marlowe wrote:> > > On Tue, Sep 9, 2008 at 9:35 AM, Amber <guxiaobo1982(at)hotmail(dot)com> 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 calculatio
ns 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> > > > -- > Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)> To make changes to your subscription:> http://www.postgresql.org/mailpref/pgsql-general
_________________________________________________________________
Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy!
http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us