On Tue, Sep 9, 2008 at 11:17 PM, 小波 顾 [EMAIL PROTECTED] 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
[EMAIL PROTECTED] (Amber) writes:
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
On Wed, 2008-09-10 at 00:02 -0600, Scott Marlowe wrote:
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.
I would have
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
On Tue, Sep 9, 2008 at 9:35 AM, Amber [EMAIL PROTECTED] 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
On Tue, Sep 09, 2008 at 11:35:56PM +0800, Amber 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.
No. Note that threading is not
On Tue, 09 Sep 2008 10:07:32 -0600, Scott Marlowe wrote:
On Tue, Sep 9, 2008 at 9:35 AM, Amber [EMAIL PROTECTED] 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
From: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] wrote: We
know PostgreSQL uses one dedicated server