Re: PostgreSQL process architecture question. - Mailing list pgsql-general

From Scott Marlowe
Subject Re: PostgreSQL process architecture question.
Date
Msg-id dcc563d10809092302p39655a4di9bfb1d734e144633@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL process architecture question.  (小波 顾 <guxiaobo1982@hotmail.com>)
Responses Re: PostgreSQL process architecture question.  (Reece Hart <reece@harts.net>)
List pgsql-general
On Tue, Sep 9, 2008 at 11:17 PM, 小波 顾 <guxiaobo1982@hotmail.com> wrote:
> 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.

Unless you have either a small data set or a very powerful RAID array,
most the time you won't be CPU bound anyway.  But it would be nice to
see some work come out to parallelize some of the work done in the
back end.

pgsql-general by date:

Previous
From: 小波 顾
Date:
Subject: Re: PostgreSQL process architecture question.
Next
From: Artacus
Date:
Subject: Re: psql scripting tutorials