Re: Hardware Config - Mailing list pgsql-general

From Richard Huxton
Subject Re: Hardware Config
Date
Msg-id 008501c0fa2f$affeeb60$1001a8c0@archonet.com
Whole thread Raw
In response to Re: Hardware Config  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
List pgsql-general
From: "Steve Wolfe" <steve@iboats.com>

> > > Will PostgreSQL take advantage of more than 1 CPU? If so, are there
> any
> > > benchmarks showing how it scales with multiple CPUs?
>
>    We run PG on a quad xeon, and it works wonderfully.  From PG's design
> of forking off a new backend for each connection, it is inherantly
> scalable, as each backend can run on another CPU.  And, of course, having
> extra CPU's to handle kernel code, I/O, interrupts, and other things is
> always good.

Although the original poster should know that it won't spread the cost of
one large query over several CPU's (which I believe Oracle can be made to
do).

- Richard Huxton


pgsql-general by date:

Previous
From: Michael Meskes
Date:
Subject: Re: Use of C function parameters from embedded SQL
Next
From: "Richard Huxton"
Date:
Subject: Re: Postgres is too slow?