Re: PostgreSQL process architecture question.

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: 小波 顾 <guxiaobo1982(at)hotmail(dot)com>
Cc: "Holger Hoffstaette" <holger(at)wizards(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL process architecture question.
Date: 2008-09-10 06:02:14
Message-ID: dcc563d10809092302p39655a4di9bfb1d734e144633@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Sep 9, 2008 at 11:17 PM, 小波 顾 <guxiaobo1982(at)hotmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Artacus 2008-09-10 06:46:32 Re: psql scripting tutorials
Previous Message 小波 顾 2008-09-10 05:17:55 Re: PostgreSQL process architecture question.