Re: Postgres and multiprocessor? - Mailing list pgsql-admin

From scott.marlowe
Subject Re: Postgres and multiprocessor?
Date
Msg-id Pine.LNX.4.33.0403081408430.2365-100000@css120.ihs.com
Whole thread Raw
In response to Postgres and multiprocessor?  (mlists <mlists@panforma.co.yu>)
Responses Re: Postgres and multiprocessor?  (Juan Miguel <juanmime@ono.com>)
List pgsql-admin
On Mon, 8 Mar 2004, mlists wrote:

> Can PostgreSQL use multiple processors if they are present in a
> computer, and if so, how much will it speed up database server? Tnx in
> advance.

Yes, Postgresql can use >1 CPU.  Each process can use one, and only one
CPU by itself.  however, the OS can use another CPU, and another user can
use another CPU.

The difference it makes depends greatly on your load.  If your database
application is CPU intensive, and currently CPU bound, then yes, of
course, the extra CPUS will help.  If your application is I/O / memory BW
bound, then no, extra CPUs won't help much.


pgsql-admin by date:

Previous
From: Silvana Di Martino
Date:
Subject: Re: pgcrypto and database encryption
Next
From: Silvana Di Martino
Date:
Subject: Re: Database Encryption (now required by law in Italy)