Re: One or more processor ? - Mailing list pgsql-performance

From Dennis Bjorklund
Subject Re: One or more processor ?
Date
Msg-id Pine.LNX.4.44.0310101836540.32606-100000@zigo.dhs.org
Whole thread Raw
In response to One or more processor ?  (Hervé Piedvache <herve@elma.fr>)
List pgsql-performance
On Fri, 10 Oct 2003, [iso-8859-15] Hervé Piedvache wrote:

> A simple question about PostgreSQL ... I have a Pentium Xeon Quadri
> processors ... If I do a SQL request ... does PostgreSQL use one or more
> processor ?

Each connection becomes a process, and each process runs on one processor.
So, with only one connection you use only one processor (and the OS might
use an other processor). Most databases has many concurrent users and then
it will use more processors.

--
/Dennis


pgsql-performance by date:

Previous
From: Hervé Piedvache
Date:
Subject: PostgreSQL Scalable ?
Next
From: Bill Moran
Date:
Subject: Re: One or more processor ?