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